Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have built the bar chart pictured below using two dimensions
- Month Name
- Pre
I have the relative box selected in the Expression dialogue to show the percentage of each Pre value.
This is not working how I want it to. I would want to see the percentage of each Pre value PER Month Name. Instead, it is giving me the percentage of all of the Pre values split up between month names.
I am sure this is an easy fix but I have not been able to resolve. Any help is appreciated.
Go to presentation tab and select check this option
Instead of relative value use a calculation to calculate the percentage. Let's assume your expression is Sum(Sales), change it to:
Sum(Sales)/Sum(TOTAL <MonthYear> Sales)
Ok Sunny. Used that as a work around to the relative box ... How do I get each specific percentage to display on the chart instead of a total percentage at the top?
Go to presentation tab and select check this option