Pivot chart - columns with Totals

[#1]

I can't seem to get totals into my pivot chart.

I'm looking for this result:

BU	Cluster	Site	Process	Activity	UOM	Tot Act. Hr	08-09 Act. Hr	09-09 Act. Hr	10-09 Act. HR
			Inbound	Unload	Pallets	147	60	40	47
			Outbound	Pick	Boxes	330	110	122	98
			Outbound	Load	Pallets	130	50	50	30
			Operations	Supervision	Hour	36	16	8	12

In my example I've added 3 days, but it should be possible to show every day of the year.

For the column Tot Act. Hr I'm trying to add a calculated dimension - but I'm not getting the calculation right.

Can anyone help me out?

[Gysbert_Wassenaar · Accepted solution]

You need to use the aggr function in the calculated dimension. See attached qvw.

[#3]

aggr(sum([Total Act],Process)