2 Replies Latest reply on Oct 18, 2018 12:18 PM by Phillip Bishop

    How to display Top N total instead of Grand Total

    Phillip Bishop

      I am using a Top N Customers Parameter with 3 selections: 25, 50 & 100.  I would like to be able to show the total sales(not Grand Total of all sales) for whichever Top N Customers selection I click on.  I tried using a IF/SUM calculation, but I cannot get around the error that says I can't compare integer and string values.  Below is the formula I am using.  Please help!

       

      Sum(IF([Top N Customers Parameter]="25"

      OR([Top N Customers Parameter]="50"

      OR([Top N Customers Parameter]="100"

      )))THEN[Bookings Net]END)