Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a small issue with pivot table, i am use two expressions like actual and actual%. if i select period 1 actual and actual percentage displays perfect, if i select period 1,2,3, actual displays perfect but actual% not displays right values following is attachment
period 1 actual actual%
------------ ------------ -----------
Gross Revenue xxx 100%
Period 1 actual actual% Period2 actual actual% Period3 actual actual%
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Gross Revenue xxx 31% Gross Revenue xxx 33% Gross Revenue xxx 33%
i want each actuals also 100% please assist me
this is my expression