When i create a pivot table it counts the formula as an item (the formula is a IF statement and false is set to ""). Example - 3 out of 5 are true so a value is visible but when i pivot, the count for that column is 5 and not 3. Is there a way to make it read like a true empty cell either through formatting or VBA? thanks in advance for reading this...i've been beating my head against the wall for the past couple of days trying to figure this out.
thanks,
RJ
thanks,
RJ