Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
i using a pivot table and am trying to count stores name in each region depending on user selection ,in total filed ,
in this example we need to show that there is 2 store in central region and 1 store in each other, any suggest to do that and NOTE that is depending on user selection .
thanks
Hi, could you do a Count (STR) measure, adding it by Region:
sum (count (Aggr (STR), Region))
actually its showing an error message (Nested Aggregation not allowed)?
Are you creating a measure or dimension?
sure its measures ....?