1 Reply Latest reply on Mar 5, 2017 6:30 AM by Joe Oppelt

    on selecting filter rank is changing

    Manish Ray

      Hi all,

      I am working  on a report where I have data for sales of different vendor, on the basis of their sales for different product and their unit sales , I have calculated their rank quartile for individual product on the basis of their unit sales and amount sales across all vendors, now on selecting any single vendor my ranking for the product on unit sales and amount sales is changing,
      suggest me the appropriate solution

        • 1. Re: on selecting filter rank is changing
          Joe Oppelt

          Quick filters remove rows from the table entirely.  RANK() works on the current rows in the table.  So you need to filter in a way that doesn't remove rows.

           

          TABLE CALCS used as a filter will not remove the rows.  It just removes what is displayed.

           

          LOOKUP(ATTR([Vendor],0)

           

          Create this calc, put it on your filter shelf in place of your [Vendor] filter.  Show Filter.  You'll see that it works just like the [Vendor] filter, but it doesn't change your RANK calc.