OS: XPP
XL: 2007
My pivot table is not showing a quantity though the row label and column label does show. All other quantities for the field are showing. The result in a chart is that the row label value shows but no quantity.
I am filtering for Top 75% of the field entries.
Incidentally if I use to related fields, one with category and the other subcategory, and I filter each for Top 75% of its entries is that the same as if I used a combined or concatenated field with Top 75%? They appear to be equal but am suspicious not so.
Thanks for the help.
XL: 2007
My pivot table is not showing a quantity though the row label and column label does show. All other quantities for the field are showing. The result in a chart is that the row label value shows but no quantity.
I am filtering for Top 75% of the field entries.
Incidentally if I use to related fields, one with category and the other subcategory, and I filter each for Top 75% of its entries is that the same as if I used a combined or concatenated field with Top 75%? They appear to be equal but am suspicious not so.
Thanks for the help.
