total multiple pivot tables

[vincesavoldi]

I have a report that shows 3 pivot tables on the same page. What we would like to do is total (or perhaps subtotal) the three tables into a summary table.

each table has
number code, name, data 1, data 2.

The three tables are identical with the exception of I filter on only specific number codes.

Currently I simply have a 4th pivot table with all the number codes and just hide all the rows except top and totals.

I would love to be able to use something like subtotal to simply display the totals (from my 3 tables)

Any ideas?

 

[Geotch]

I use Mike Alexander's trick for most of my crosstab needs now. It helps with issues like you are having. One thing that he leaves out is to do an "all other" just in case you miss something.

Here's his video.
http://www.datapigtechnologies.com/f.../crosstab.html

 

[vincesavoldi]

I use Mike Alexander's trick for most of my crosstab needs now. It helps with issues like you are having. One thing that he leaves out is to do an "all other" just in case you miss something.

Here's his video.
http://www.datapigtechnologies.com/f.../crosstab.html

Unfortunately that link didn't work and I couldn't find the article by browsing it.

 

[Geotch]

See if this helps. I guess he took the video down. http://www.accessandexcelhelp.com/m...ion-of-a-pivot-table-the-crosstab-query-trick