Pivot table issue

[#1]

Hi all,

I have small issue with pivot table please assist me,

i have a two expressions like "actual" and "actual%". and i my dimension "Period".

if i select Period 1 the following data is displaying

                                Actual          Actual%

Gross revenue            100000            100%

if i select Period 1,2,3 at a time with list box filter the following values are displaying.

      Period1           Actual          Actual%        Period2    Actual      Actual%          Period3    Actual        Actual%

Gross revenue     100000            31.08%                      120000        34.01%                      1400000          34.91%

I want to display actual% also 100% each period like the following

  Period1             Actual         Actual%      Period2    Actual      Actual%         Period3    Actual        Actual%

Gross revenue    100000            100%                     120000          100%                      1400000          100%

[rahulpawarb]

Hello Raja,

Trust that you are doing good!

Given requirement is ambiguous to me. Could you please share the application or share the expression definitions? This will help us to further analyze the issue and provide you expected response.

Regards!

Rahul

[#3]

find my screen shot, i think so this is helpful

[Anonymous]

What is the value of vRev??

[#5]

vREV  =  16029213

[#6]

vREV is different period to period

u can find it above screen shots, and actual is dispalying correct values but actual% is not like that it disaplys the value is "actual% / period number"