Forum Discussion
Highlight differences between totals by category
I have the below table which shows total dollars by category (x-axis) for each Name (color). This is used to show the differences in cost from one Name to another.
Is there anyway to show some kind of difference, percent change, etc. to highlight the savings or extra cost between the names?
If needed, this page can be limited to show only two (or three) 'Names' at a time.
3 Replies
Hi Anonymous,
Is there anyway to show some kind of difference, percent change, etc. to highlight the savings or extra cost between the names?
If needed, this page can be limited to show only two (or three) 'Names' at a time.
I'm not very clear about your requirement. Do you want to a visual to show some kind of difference, percent change, etc. to highlight the savings or extra cost between the names?
If it is convenient, could you show your data sample and your desired output?
Best Regards,
Cherry
Hi - v-piga-msft,
Exactly as you said, I'm trying to show some kind of difference, percent change, etc. to highlight the savings or extra cost between the names.
Here some sample data (If possible I'd like this solution to be able to handle more than two names, but I would be happy with just a comparison of two).
Name Category Amount A 1 5 A 1 5 A 2 15 B 1 0 B 1 10 B 2 2 B 2 3 Here is one idea I had to highlight the differences between the 'Names', but I am in no way locked into this. I am open to any better suggestions!
