caliculate sum formula in pivot table

[surendraj]

Hi Guys,

I have a requirement where my values are in pivot table 

                      date               April 1                           May  1

                     Type   count     value  total            count     value    total      whole total

                      Type 1   3            5          15(3*5)       3              4           12           15+12=27

Product      Type 2   4          6           24                4             7             28           24+28=52

Please suggest me how to caliculate that whole total value in my pivot table..

--Surendra

[MindaugasBacius]

This might help:

[surendraj]

No it is giving full total..by row wise.

and we have also several expressions in expressions tab.

That whole total value should came(pick) from each date wise.

[juliensaintmaxent3113]

Hi,

I think you must calculate each values with set analysis per month and on the last the cumul with the function column.

Sum({$<Month={'April'}>value)

Sum({$<Month={'April'}>Volume)

Column(1)*column(2)

etc

you can automatise the value of the month also.

Bye