1 2 Previous Next 16 Replies Latest reply on May 28, 2018 3:31 PM by Cesar Navarro

    How can I rank, and filter at the same time?

    Peter Gilks

      Here's a challenge I currently have.


      I want to show the sales rank of a single product, from universe of products. E.g. Product X is the 3rd top selling product between such and such time period.


      This product needs to be the same product as one selected by a single select filter which controls the rest of a dashboard. Of course when I use the filter, the rank is always 1.


      And here's the tricky part, I can't use parameters because the list of products is continually updating......


      I'm fresh out of ideas..... LOD doesn't seem to work with table calcs.... any suggestions?


      See attached workbook for a clue as to what I'm going for

        1 2 Previous Next