Hi everyone,
i'm working on a dashboard where I have to show the rank(sum(revenue)) of a selected shop. I have to show the result for the selected shop only and not for every shop, so i think i can't use a table calculation like rank() because if I do and then apply filter on shop, the result is 1 no matter what shop i have selected.
i have table like this
and I'd like to build a calculation to have "1" if i apply a filter on shop 1543, "2 " on shop 1546, etc ...
something like {fixed id shop : rank(sum (revenue))}, that i can't use because it's not possible to use table calculation with LOD.
thank you so much !
@Céline Vantyghem
Hi, you may use a parameter, and a expression similar to:
{SUM({FIXED [Sub-Category]:IF SUM([Sales])>SUM(
{SUM(IF [Sub-Category]=[Sub-Category Selected] THEN [Sales] ELSE 0 END)}
) THEN 1 ELSE 0 END
})} + 1
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
