Double Pivot Table - Match Subtotal Rows

  • Thread starter Thread starter Mathew P Bennett
  • Start date Start date
M

Mathew P Bennett

Good Evening Guys,
It's me again ref PTs.
I have now a w/s with two PT's next to each other- identical apart from the
top level filter (07 & 08). Now, because both PTs reference the same master
sheet, which is based on a set of (yes!) Nominal Legder codes, if in the 07
data, there is no transactions, then the PTwill ignore - so there is no row
for that NL code.

Is there a way to force the PT to show the row for the relevent NL
code-(showing a 0 value), even though there is nothing against that code,
even though it exists!
Hopefully then the two PTs subtotals will match on the same rows.

As always, thank you for all consideration.
PS. Bought Deborah's PT book today - Amazon (Well, my work did for me!)
And I am plumping for FastExcel.

Cheers Mathew
 
Mathew, instead of using two pivot tables you could use 07 and 08 as column
labels, that way they would match. But I doubt that your spreadsheet has the
same number of and identical codes for both years, remove all fields from the
Values area and check that you have an identical No. of Row Labels.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data in my pivot table changes to zeros 3
Pivot table subtotals 2
Pivot table chart problem, How to show different subtotal levels 2
Keep the word (blank) out of Pivot Table? 2
Pivot Table Subtotals 1
Multiple formulas in subtotal 2
% of subtotal in pivot table 1
Average of Subtotals in Pivot Table 0

Back
Top