6 Replies Latest reply on Feb 11, 2016 8:08 AM by JayC

    Top N based on % change - Help please

    JayC

      Hi All,

      Need help please-

       

      Background:

      I have 2 dimensions say "send_city" & "recv_city"

      Have measures like "salesold", salesnew", "profitold", "profitnew" and so on...

       

      Reqmt:

      I want to have % difference calculated between old and new fields with parameter selection having values like sales, profit, shipping cost etc.,

      Ideally objective is to find out "Top N"

                                              "send_city" TO "recv_city"

                               where % diff between say salesold and salesnew fields  >= 10%

      On top parameter should keep switching sales/profit/shipping cost etc., based on selection

       

      Please help!