Forum Discussion
PIVOT TABLE and CHART hiding blank cell HELP
I'm having trouble with my pivot table & chart. Basically, I have tons of housing data where each entry (Each house) has an assigned county, high school, price, and status (either "Sold" or "Active...
It's hard to help without a sample of the original spreadsheet itself, so if it's possible (especially if the suggestions you receive don't work), could you upload such a sample?
In the meantime, one thought that occurs to me is to work with your raw data first, to create a "helper column" that does that calculation on the comparison of the numbers sold vs the numbers active, putting the result into the "Sold"
Or maybe it's a matter of using subtotals by town or county or zipcode--whatever that horizontal axis is--
In any event, I'd try to tackle it at the level of the data itself before creating the Pivot Table.