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