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:





      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.