Hello!
I have a metric I am looking at in a pie chart. There are different categories of foods that are brought in to the US every year. I am displaying them on a pie chart so the reader can see how some categories represent more of the whole than the others.
There is a filter on the side that lets the user cycle back and forth between years to see different markups.
I would like to get the difference between 2 years and put them on a single pie chart so a reader could look and infer something like: "There was an XYZ% difference in category ABC from year 2000 and year 2010."
Using the DIFFERENCE quick calculation is giving me some issue because and I am thinking it is because this is a not a chart on an x-y axis. If the reader could pick a the years and have the pie chart shift dynamically that would be the ideal thing. I am not sure if that is possible or if I have to give up on that idea.
If anyone has some insight on a way around this issue I would be very appreciative.
Thank you!
Hi @Xavier Patrick
Here it is
Check these:
I also included percent difference charts
Check the attached workbook and let me know if it is correct
Thanks,
Said
(Please upvote all my answers and select them as the best if you found them helpful)
