Pivot table grouping 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%

[Frank_Hartmann]

Please avoid double postings!

Pivot table issue

[#3]

then if u find any solution please assist am stuck there