I have a pivot table with 100 accounts showing charges against each account for each month over a time span. When I show a table with accounts listed in rows and monthly charges in columns, I get 100 rows of data with the grand total in the rightmost column. THINGS ARE GOOD.
When I build a table showing subtotals of charges over shorter time spans, some accounts will have no charges, and rows are not shown for the zero-value accounts. Hence, I get something less than 100 rows of data. NOT WHAT I WANT.
My objective is to build a table with 100 rows and various time span subtotals in columns. I am attempting to build this final table by manipulating the pivot table and cutting & pasting the grandtotal and/or subtotals into a final table (repeated as needed). THIS IS AN OBSTACLE.
The problem is that the number of rows changes depending on how many rows have zero values. Is there a way to force each pivot table to show 100 rows even if some of the values are zero? YOUR EXPERTISE IS NEEDED HERE.
Your help will be greatly appreciated.
When I build a table showing subtotals of charges over shorter time spans, some accounts will have no charges, and rows are not shown for the zero-value accounts. Hence, I get something less than 100 rows of data. NOT WHAT I WANT.
My objective is to build a table with 100 rows and various time span subtotals in columns. I am attempting to build this final table by manipulating the pivot table and cutting & pasting the grandtotal and/or subtotals into a final table (repeated as needed). THIS IS AN OBSTACLE.
The problem is that the number of rows changes depending on how many rows have zero values. Is there a way to force each pivot table to show 100 rows even if some of the values are zero? YOUR EXPERTISE IS NEEDED HERE.
Your help will be greatly appreciated.
