How to customize total column in pivot table

[#1]

dear friends,

I have coulumn A, Column B,Coulmn C in a pivot chart. The default Total column of Pivot table takes A+B+C by default.

I want the default Total Coulmn of Pivot Table as Coulmn A+Column B.

Please help.

How to achieve this in qlikview?

	Total	Column A	Column B	Column C
Orders	20	10	10	10
Forecast	40	20	20	20

[Gysbert_Wassenaar]

Perhaps with expressions like this:

     If(SecondaryDimensionality()=0, sum({<MyDim={'Column A', 'Column B'}>} Orders) , sum(Orders))

Replace MyDim with the name of the field that contains the values 'Column A', 'Column B' and 'Column C'

[#3]

Can u please provide a sample application?

When I applied this formula it is not working properly for me. Please help

[Gysbert_Wassenaar]

Can u please provide a sample application?

No, I'm lazy. Can you?

[trdandamudi]

May be as attached: