Groupping Total in Pivot table

[vikasmahajan]

Dear all

I have following type of  pivot table for calculating P&L

GROUP	TYPE	AMOUNT
A	INCOME	58000
B	EXPENSE	45000
TOTAL(A-B)		13000

In pivot table I want to display (A-B) total  how to achieve the same .

Thanks in adv

Vikas

[avinashelite]

Hi Vikas,

If you want to added it as a new column they you can simply added it as expression but if you want it as a row value then try with the rangesum() and above() combination to get read the previous value and get the difference out of it

[PrashantSangle · Accepted solution]

Hi,

Try in expression column

sum(if(wildmatch(Type,'Expense'),Amount * -1,Amount))

and if you dont want show Expense amount in negative then go to Number tab select Integer/Fixed to

and set below pattern

#,##0.00;#,##0.00;

Regards

[Anonymous]

Hi Vikas

Here is solution (data file was connected with qvw).

Regards, Alex

[vikasmahajan]

Thanks to all  how has replied ,

I have Create Dummy Scenario for the same Find attached QVW with my requirement can any one tell me how to achieve the same .

Total

C =  A + B  

in pivot table.

Thanks

Vikas