Hello you knowledgeable people, I hope someone can help me or at least tell me if it's not possible.
I have several pivot tables that generate from a very large sheet of values broken down into sections. The values for these are either numeric or N/A and I have the pivots calculate average values from the data.
My problem is that some of my sections are completely valued with N/A and when the pivot result is calculated it shows 0%. What I am trying to get is this value to be 100% as it used in performance metrics, or even better for the pivot to show N/A.
Is there a way to do this ?
Bookmarks