Calculating the total of each value from a especific field

[#1]

Hello everyone,

I am creating a bar chart which displays the percentage of Red and Green from each Area, as you can see below:

The chart show the total percentage considering all areas, but i need to display the total percentage of each area, so i  divide each count by the total count by Area, like this (instead of using the checkbox "Relative"):

Count (DISTINCT [Status mês]) / Count (DISTINCT TOTAL <Area> [Status mês])

And than, the chart displays the total of Red and total of Green by area:

But something is wrong with the expression. The field "Recrutamento e Sel..." has 5 green values and 1 red value.

So, it was supposed to display 83,3% Green and 16,7% Red.

Someone see why my expression is not working?

Regards

[MK_QSL · Accepted solution]

You need to either provide sample data or sample file.. Without that it is difficult to guess..

Or you can try removing DISTINCT words from Numerator and Denominator both..

[#3]

Thank you Manish, the DISTINCT was wrong. removing it calculated right.