adding column in pivot table

[#1]

Hi Friends,

i would like to add a column name as total sales in the below given table with respect to year and Business unit wise,

so can any one suggest me how can i do this?

[Anonymous]

Add one more expression say Total Sales in exprssion properties:

like:

Total Sales=sum(Central Ops Expression)+Sum(OFS Expression)+sum(PE)+sum(TI)

[PrashantSangle]

Hi,

Select Partial Sum from chart Property->Presentation tab

Regards

[tamilarasu · Accepted solution]

Goto presentation tab and enable partial sum for Business Unit dimension

[#5]

Hi,

Thank you for the reply,

if i select the Partial sum as you said, it is showing at the top or bottom, but i want to show it at the last (right side).

any idea about it?

[#6]

Thanks a lot Tamil