7 Replies Latest reply: Jun 11, 2018 2:56 PM by Leszek Piekielniak RSS

    Divide with set analysis

    Leszek Piekielniak

      Hi all,

       

      I have created the below pivot table:

       

      Capture.JPG

       

       

      now I am trying to do insert KPI that will show the value of Salaries & Additional Support divided by Casual Team.

       

      I use the below expression:

       

      sum({$<Grouping={'Salaries & Additional Support'}>} AMOUNT )/

      sum({$<Grouping={'Casual Team'}>} AMOUNT )

       

      but the results in incorrect.

       

      Could someone more experienced help with this?

       

      Thank you in advance for your assistance.

       

      thanks,

       

      Leszek