Show Relative Expression per Dimension

[Anonymous]

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.

[sunny_talwar]

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)

[Anonymous]

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?

[sunny_talwar · Accepted solution]

Go to presentation tab and select check this option