PIVOT TABLE WITH BLANK CELLS


G

Guest

I need some assistance - I have created a pivot table with a lot of data from
an excel spreadsheet. When you click on the data in the pivot chart to open
details about what the data represents it sorts the data wierd because there
are blank cells. It will not ignore these cells unless I put a zero in
there...?? Is there someway to have the pivot only display data that is
populated within a certain column?
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top