I'm having and issue and I want to know the best way to fit it.
I have a cube about orders countries, salesmans, customers. In a dashboard, I want to show the detailed sell behaviour of a city. So I have to set a city filter in this dahsboard. But one of my requirements is to show a KPI with the rank of that city for sales in the country.
As the dashboard is filtered by city, RANK function always shows 1 as result:
and I cannot put an ALL in RANK group by expression ( ALL([country]) gives me an error). If I disable city filter for this widget I'm going to show all cities in that widget, but I want to show filtered city in this widget only, and the rank in the right value. I have another filters in the dashboard, so I think that I cannot calculate this rank in the cube.
I think that this is a common question, do you have any idea?
Thanks in advance!
Please sign in to leave a comment.