Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Total % is different in each bar not 100% in each bar
Check the image attached below
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 %
It's working perfectly
Check the image below attached
Good