In the pivot table, double-click on the Type button in the row area.
Add a check mark to 'Show items with no data', then click OK
Then all the types should show, even if they have no data for the
selected city.
alanas wrote:
Dear Debra Dalgleish,
thank you for your responses and willingness to help. I understand my
problem and I think it's impossible to show that data in PivotTable. The
problem is not in the resulting PivotTable, that's in initial (source) data.
For example it looks like this:
City Type
NY a
NY a
NY b
Tokyo a
Tokyo a
Tokyo b
Tokyo c
Tokyo c
And from this table I'm building next PivotTable:
Page field: Cities: (All)
Rows field: Data field:
Types Sum of Types
b 2
a 4
c 3
But if I filter by NY (city). I will see next PivotTable:
Page field: Cities: NY
Rows field: Data field:
Types Sum of Types
b 1
a 2
But, anyway I wanted to see one more row like: c 0. Is it possible???
alanas.
P.S. I hope it was understandable.
"Debra Dalgleish" wrote:
How are the zero rows being automatically hidden?
alanas wrote:
1) I am using Excel 2003
2) Yes I have. And "01.03.08" is checked there to be shown. But anyway, that
is not displayed in the Rows field, because "Sales" equals to 0 (in Data
field).
So How can I solve it in PivotTables?
alanas
"Debra Dalgleish" wrote:
What version of Excel are you using?
Do you have a filter on the values?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html