Hello,
I have a basic question:
Suppose I have a table with 3 columns :
City / Month / Value
An I have 100 cities for example.
I want to create a pivot table by using a DAX measure,
for only the top 10 of cities, and have the sum of values for each of the 10.
Actually I want simply do like the existing TOPN function of Excel pivot tables...
I have tried TOPN and RANKX DAX functions, but each time I still have ALL the 100 cities in my pivot table.
How could I do that ?
Thank you for your help.
I have a basic question:
Suppose I have a table with 3 columns :
City / Month / Value
An I have 100 cities for example.
I want to create a pivot table by using a DAX measure,
for only the top 10 of cities, and have the sum of values for each of the 10.
Actually I want simply do like the existing TOPN function of Excel pivot tables...
I have tried TOPN and RANKX DAX functions, but each time I still have ALL the 100 cities in my pivot table.
How could I do that ?
Thank you for your help.