c= a+b column total in pivot

[vikasmahajan]

Find attached QVW and excel sheet have  Group A,B, C  ... like this columns now I want to display

C =  A+B  in total of pivot.

How to achieve the same

Vikas

[giakoum]

column(1)+column(2)

[giakoum]

or if you label the expressions, you can use the labels as well. See attached

[vikasmahajan]

Dear Sir ,

Thanks reply Actually I want total in attached excel format please refer and give solution.

Vikas

[giakoum]

I really don't see any difference between excel and QV. Could you please elaborate?

[vikasmahajan]

I have different types of groups like A,B,C etc  in pivot report now I want group total suppose c= a+b

please see image attached.

Vikas

[giakoum · Accepted solution]

to do that correctly you need to introduce a new dimension that will group A & B together.

See attached as example

[vikasmahajan]

using new group and following expression solved my problem.

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

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

and set below pattern

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

Thanks

Vikas

[kavicsgym]

Hi All,

Grouping seems ok in a simple example, but normally you have much more different blocks in a P&L where you have to sum up the Totals. Pls. see the modified xls from above, as an example, and the colored 'blocks'.

Then you may need 3-4 or more columns for grouping, and it will be very confusing in a Pivot chart.

So how to cope with that, or am I misunderstanding something? (I work on a PandL right now.... 🙂  )

Enikö