3 Replies Latest reply: Apr 10, 2012 5:58 AM by Baru - RSS

    Need % calculation based on field total wise

      Hi,

       

      I  taken 3 dimensions and 6 expressions in pivot table.My requirement is to show the %calculation based on the field total wise it is in 1st dimension.

      I taken expression is

      sum({$<YEAR = {$(=max(YEAR))}, MONTH = {"<=$(=max({<YEAR={$(=max(YEAR))}>} MONTH))>$(=max({<YEAR={$(=max(YEAR))}>} MONTH)-1)"},ClosingStock={'>0'}>}  IF(AHC_CallDate = MAXDATE_CHECK, ClosingStockInCase))

       

      it is showing correct value,but i want to show this value in %,based on the total of one field

      ex:-  value=186.12, i want to divide this value with field total i.e.,35007.32

       

      requirement= (186.12/35007.32)*100

                      = 0.53%

       

      i am having 4fiels in 1 dimension,i want to show this calculations for different values.

       

       

      thanks,

      ba