Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
steps1989
Contributor II
Contributor II

Count dimention in pivot table

Hi ,

i using a pivot table and am trying to count stores name in each region depending on user selection ,in total filed , 

count of STRcount of STR

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

Labels (3)
4 Replies
Esegarra
Partner - Contributor
Partner - Contributor

Hi, could you do a Count (STR) measure, adding it by Region:

sum (count (Aggr (STR), Region))

steps1989
Contributor II
Contributor II
Author

actually its showing an error message (Nested Aggregation not allowed)?

Esegarra
Partner - Contributor
Partner - Contributor

Are you creating a measure or dimension?

steps1989
Contributor II
Contributor II
Author

sure its measures ....?