I'd like to create a side-by-side bar chart with one bar showing the percentage in running total for all dimensions and the other bar showing the percentage in running total for dimensions based on a filter. I've attempted to do this with a FIXED formula but haven't had any luck.
4 answers
Created this calculated field on the Superstore data:
Here is the output:
1. With all Categories
2. With some categories filtered out:
Does this help?
