Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
% of Subtotal In Pivot Table | Excel Worksheet Functions | |||
% of subtotal in pivot table | Excel Discussion (Misc queries) | |||
Select all subtotal rows on Pivot Table | Excel Worksheet Functions | |||
Subtotal in a pivot table | Excel Discussion (Misc queries) | |||
Subtotal vs Pivot table - or best way | Excel Discussion (Misc queries) |