Good Day,
I please need some help with the attached file. Tabe named "Leads&Conv Score" The orange highlighted columns have been built in.
When I select a slicer for the pivot table, i would like to see blank cells where there is no further data on the pivot table.
E.g. In the attached you will see that the slicer selection is on "centurion & midrand", From Cell H26:Z64, I would like to see blank cells, as the pivot data only runs up until cell G25.
Appreciate the assistance.
Regards
Keshypops
You need to wrap your formulas in if statements like so:
=IF(OR(ISBLANK(A15),A15="Grand Total"),"",10)
=IF(OR(ISBLANK(A15),A15="Grand Total"),"",IFERROR((B15/H15),0))
and so on.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks