2 Replies Latest reply: Sep 22, 2015 7:41 AM by Tresesco B RSS

    Total

    ilan baruch

      Hi All,

      I'm trying to calculate relative amount (pivot table) with excluded dimension :

       

      sum(amount) / sum(TOTAL <item_name> amount)

       

      but result comes as :

       

      sum((amount)/sum(TOTAL amount)

       

      any ideas?