help With Pivot tables

[lk26]

Hi,

I have a Spreadsheet and within it there is a column with dates and some cells are blank. when i make a pivot table with this spreadsheet, the blank cells show up with "(blank)" in them. Can I tell it not to put the "(blank)" in the cells and just actually be a blank cell?

Sincerely,

Lauretta​

 

[lk26]

If you're moving the billing to a new online system and that system has the ability to generate csv reports, I would suspect that system has the ability for you to generate a custom report/query to pull all relevant fields into a single report that excludes equipment which has already been "final billed". If you aren't allowed to create a custom report, perhaps the online company could create one for you for a nominal fee, or better yet create the projected billings report you're looking for.

If you're stuck with the 2 reports method, let me know if the vlookup formulas I gave earlier are working properly - once you have it in a single report we can work on the projection formulas.

I will work on it and let you know. Right now, I am stuck with the 2 reports method. I appreciate your help!!