Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am getting this error in stacked bar chart.Can anyone advise this ?
When select particular value it shows complete graph.
How is your expression looks like?
This is my expression sample
Sum(Sales)
/
Sum( total <Dim 1>Sales)
Try this:
Sum(Sales)
/
Sum({1} total <Dim 1>Sales)
Hi Arthur,
Thanks for suggestion. I don't think formula making problem here.
I have tried changing the expression and here is the result.
Expression 1:
Sum([Total working minutes])/
Sum(TOTAL<Team>[Total working minutes])
Result:
Expression 2:
Sum([Total working minutes])/
Sum(TOTAL[Total working minutes])
Result:
Hope this helps.
Thanks and regards,
Arthur Fong
Hi all,
Anyone please help this issue?
Is <Dim 1> your chart dimension?
Yes Dim1
From error in the chart do you mean some of the bars are not adding to 100%?
Can you see how your data is different than the attached sample app I have created.
Thanks,
DJ