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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
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 |