Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show items with no data on rows | Excel Discussion (Misc queries) | |||
Data Items Values In Pivot Tables/Charts | Excel Discussion (Misc queries) | |||
show items with no data option in pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Pivot Tables, can I use an external list to select data items? | Excel Worksheet Functions |