I have table similar to below. RankData1 and RankData2 is Rank() function of Data1,Data2 respectively.
|
I have been trying to reset RankData2 when Data is filtered by RankData1. Below is what i have. Is there way to reset RankData2
Customer | Data1 | Data2 | RankData1 | RankData2 |
B | 34 | 44 | 3 | 1 |
D | 45 | 15 | 2 | 5 |
E | 61 | 8 | 1 | 6 |
Filters on table calculations gets executed at the end of all operations. So i don't think you can rank it after table calc filters.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.