I have a data set with customers, and the fields:
- CustomerNumber
- Category
They can be category: none, Gold or Platinum.
I need a pivot graph that shows the % of Gold and Platinum customers, and not showing the "none" value.
But, I don't know how to remove the "none" part from the data, but they should count as a base line for %.
This is what i get (with % Running of total in):
Gold - 50%
Platinum - 20%
none - 30%
For the pivot TABLE, that's fine. But not in a line graph, it should stop at 70% (50+20) and not go to 100%.
Help![]()
Bookmarks