pivot table - sum all data section to ONE cell

[fishysheep]

Hi
Assuming i have pivot based on following fields:

date time place TotalA TotalB TotalC

pivot looks as as follows:

1 Jan 05 9:00 London 100
101
102

2 Jan 05 11:00 Swindon 200
201
202

where figures at end are TotalA, TotalB etc

is it possible to have

1 Jan 05 9:00 London 303
2 Jan 05 11:00 Swindon 603

so that totals A+B+C are summed?

I know I could add them up on the sp and use that total col in the pivot but I'm hoping to avoid that.

Thanks

 

[Gavona]

Right click on the pivot table. Calculated Field and create a new field equal to TotalA + TotalB +TotalC.


Thanks,

Gavin

 

[ETID]

One other Note:

"Calculated Field" may have to be accessed through the Pivot Table ToolBar.

 

[SkipVought]

fish,

That's the problem with a non-normalized table. If your data were normalized, you could do that in your PT.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}