Totals in Pivot tables

[#1]

Hi Guys,

I have a pivot table as in the example below.

I need to allow users to select "showing total" by diferent expressions, or no totals at all.

For example, Getting Totals by "Parent CC" or getting totals by "LE / Cost Center", or no total at all.

Is there any nice work around without using macro?

Thanks in advance,

Aldo.

Parent CC	LE / Cost center	Expense Type	Budget	Actual
Parent CC 1	1	Expense 1	605	99
		Expense 2	644	473
	2	Expense 1	187	44
		Expense 3	7	0
	2	Expense 2	347	380
Parent CC 2	51	Expense 1	691	0
		Expense 2	50	0

[Gysbert_Wassenaar · Accepted solution]

In QV11 it's fairly easily done with two variables and conditional expressions for the two dimensions. See attached example.

[#3]

Nice & Easy,

(It would be nice having the posibility to do it witha condition instead of duplicating...).

Thanks 🙂

Aldo.