My data has a field that is blank for half of my rows.
My pivot table displays this with the text "(blank)". Is it possible for my pivot table to be blank where there is no data?
Thank you!
My data has a field that is blank for half of my rows.
My pivot table displays this with the text "(blank)". Is it possible for my pivot table to be blank where there is no data?
Thank you!
Hello,
in the pivot table select the field filter and untick "(blank)".
regards, LMP
I had this same issue with a formula once and I actually just simply had to change the part in the formula from "(blank)" to ""
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks