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)

[YoussefBelloum]

Hi,

can you attach sample app or data ?

[vanand3535]

Please find the attachment

[YoussefBelloum]

just re attach the file, nothing is attached now

[vanand3535]

The formulae used here is:-

Sum(Sales)/Sum(Total Sales)

Sum(CategoryName)/Sum(total CategoryName)

Sum(ProductName)/Sum(total ProductName)

[vanand3535]

I'm not finding any way to attach the app or data

or video and image attachment opting i'm getting

[YoussefBelloum]

ok but here I can't see the issue.. can you create sample data ?

[vanand3535]

I have sample data but how can  I attach the excel sheet here because here I'm only getting an option to attach image or video

[YoussefBelloum]

Use advanced editor

[vanand3535]

I have attached the sample data ,

please find the attachment !