5 Replies Latest reply: May 8, 2018 1:01 AM by Mohan Kumar RSS

    How to show the growth% in YTD/QTD/MTD in Pivot table?

    Mohan Kumar

      Hi Qliker,

       

      I wanted to show Growth % for Sales in the pivot table having dimensions shown in below snippet. I'm using the following expression to calculate the growth%.

       

      sum({$<FiscalYear={"$(=Max(FiscalYear))"},Date={"<=$(=Max(Date))"}>}sales) -

      sum({$<FiscalYear={"$(=(YEAR(Max(FiscalYear)))-1)"},Date={"<=$(=AddMonths(Max(Date),-12))"}>}sales)

      /

      sum({$<FiscalYear={"$(=(YEAR(Max(FiscalYear)))-1)"},Date={"<=$(=AddMonths(Max(Date),-12))"}>}sales)

       

      It works fine if I have only Fiscal Quarter and Month as the row dimensions. When I add the fiscal year in rows dimensions, I get the wrong output displayed in below snippet:

       

      Capture2.JPG

       

      Thanks in advance..!!!