Hi,
I am making a pivot chart (bar graph) to represent the number of transactions that happened in 196 plans. There are many plans with less than 3 transactions, and i would like to group them all together to be represented by a single bar called "All Other Plans". Is there a way to do this using a pivot chart?
The graph would show something like:
Plan 1 - 70
Plan 2 - 40
Plan 3 - 10
All Other Plans - 50 (the sum of transactions in all other plans combined)
Please let me know if i can provide any more detail. Thank you!
I am making a pivot chart (bar graph) to represent the number of transactions that happened in 196 plans. There are many plans with less than 3 transactions, and i would like to group them all together to be represented by a single bar called "All Other Plans". Is there a way to do this using a pivot chart?
The graph would show something like:
Plan 1 - 70
Plan 2 - 40
Plan 3 - 10
All Other Plans - 50 (the sum of transactions in all other plans combined)
Please let me know if i can provide any more detail. Thank you!