always display rows in Pivot tables (show items with no data)

[Tausif]

Hi,
I have a pivot table for which I always need to displays rows items.
eg) I have a column named Age bucket. (< 1 day, < 1 week, 1-2 weeks etc)
& region (London, NY etc.)
I alwayd need to display the Age buckets & regions irrespective of whether
they appear in the pivot data source or not. The age buckets which doesnt
have data can show "0" against them.
I read something about doing it via SQL, but is there nay other wya?
I have turned on the "show items with no data" under field settings for Age
bucket & region.
Thnaks,

 

[Dave Peterson]

I used to add extra rows to my original table that would have each category that
I needed--but with no data on it. Then it would appear in my pivottable with
0's.

But I couldn't use a Count of that category--the numbers would be too high for
each "dummy" row I added.

In my situation, I kept a worksheet (hidden) that had all the categories and
would just copy that data at the bottom of my real table in the code that
created and formatted the pivottable.