I want to create a bar chart displaying revenue by rank of customer in descending order of revenue, rank being on the category axis of my bar chart.

Dear all

I want to create a bar chart displaying revenue by rank of customer in descending order of revenue, rank being on the category axis of my bar chart. See attached how the graph looks like.

I would like the ranking to be adjusted based on the columns standing before the NEST. For example, if the column before NEST is country, I want to see the customer ranking within each of the countries displayed along the category axis. If there are more columns, for example country and product, the ranking should be adjusted to this. 

In the expression  <[Country] NEST DenseRank(Sum([Revenue]) over [Customer],?desc?,[Country])>

Does anyone know if [Country] as Argument of the Rank function can be replaced by another expression which will dynamically adjust to what is before the "NEST"? Parent() does not seem to work.

Also, the Rank function does not adjust based on active filters. Not sure if this can be influenced?

Thanks for any help!

Attachments

AttachmentSize
Image icon Bar chart1.jpg33.97 KB

(2) Answers

Login