Percentage in Stacked Bar Chart

[vanand3535]

I have a bar chart with

1-Dimension

3-Measure

All the 3 measures have different filters applied to it

When I am trying to find the percentage I'm not able to get 100%

Sometimes I'm getting more than 100% , sometimes less than 100%

As of now i'm using the formula for percentage is:-

count(fields)/count(total fields)

or

sum(fields)/

sum(total fields)

[vanand3535]

Total % is different in each bar not 100% in each bar

Check the image attached below

[YoussefBelloum · Accepted solution]

Ok, I see , one more time

Try this:

=sum(sales)/sum(sales+profit+discount)

=sum(profit)/sum(sales+profit+discount)

=sum(discount)/sum(sales+profit+discount)

In %

[vanand3535]

It's working perfectly

Check the image below attached

[YoussefBelloum]

Good