Message "...does not support more than 100 distinct values..." WHY????

Message "...does not support more than 100 distinct values..." WHY????

I get this message on one of my reports:

Sorry, Zoho Reports currently does not support more than 100 distinct values in columns. 'Account Name * Sum(Amount),Count(Amount Tier)' contains more than 100 distinct values. 

Possibly, you can apply filter to reduce the number of distinct values in 'Account Name' or drop the 'Account Name' field in Rows.



I want to list all ACCOUNT NAMES (about 500) with SALES BY ACCOUNT.  What is blocking this?