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

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,
--
Tausif Mohammed

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

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.

Tausif wrote:

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,
--
Tausif Mohammed

--

Dave Peterson