I have a chart only showing the top 30 clients and the sum of their sales.
(used calculated AGGR dimension).
The total rightly shows the sum of only the TOP 30...but I also need to show the TOTAL of ALL clients right below it.
IS THIS POSSIBLE? Thanks in advance!
as an FYI, the calc dimension is:
=aggr(if(rank(sum({<Year={2010}>}Sales))<=30, Client,null()),Client)