Hi all,
I have a table with data that I need to apply a report-wide slicer to. I've searched high and low, watched youtube videos, and cannot get the RankX to work the way I need it to.
I need to do a count of the occurrence of the values in the Supplier column and rank in Descending order (the most occurrences would be #1). Then there is another column which indicates plant 1, plant 2, or plant 3. That is where the report-wide slicer will apply. The closest I've gotten is a general ranking but then it doesn't update when I apply the slicer to the plant column.
This ranking will update as new data is fed to the tool daily so I need it to be dynamic.
Any ideas?
I have a table with data that I need to apply a report-wide slicer to. I've searched high and low, watched youtube videos, and cannot get the RankX to work the way I need it to.
I need to do a count of the occurrence of the values in the Supplier column and rank in Descending order (the most occurrences would be #1). Then there is another column which indicates plant 1, plant 2, or plant 3. That is where the report-wide slicer will apply. The closest I've gotten is a general ranking but then it doesn't update when I apply the slicer to the plant column.
This ranking will update as new data is fed to the tool daily so I need it to be dynamic.
Any ideas?
