1 2 Previous Next 15 Replies Latest reply on Sep 5, 2017 7:33 AM by Kenneth Buker

    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