Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My bar-chart has two dimensions Brands and Media and it is based on the expression sum(FieldName). As a result I can see media distribution inside each brand (see the file attached). The bars are the brands im my example.
I need two normalize it. I need to set 100% for each brand so that brands (bars) could be of the same height.
How can I do it?
Thank you in advance,
Larisa
Dimension
1) Field1
2) Field2
Expression
SUM(YourFactField)/SUM(TOTAL <Field1> YourFactField)
Untick Values on Data Points
SUM(Sales)
Untcik Bar
Tick Values on Data Point
Style STACKED
Hope this helps...
You need to use Total Qualifier. What are the Dimension and Expression for this chart?
Dimension
1) Field1
2) Field2
Expression
SUM(YourFactField)/SUM(TOTAL <Field1> YourFactField)
Untick Values on Data Points
SUM(Sales)
Untcik Bar
Tick Values on Data Point
Style STACKED
Hope this helps...
Thank you!