Need help

[#1]

Hi all

I have problem with bar char. In stright table i got corrent sales and sales % of total, but when i use similar expresion on yearmonth dimension in bar char i got incoret values. What i need: in bar char for each month, char max and min value of bar must bee 100%, and all sales are distributed according to % of total sales. (like in atached picture).

Please help.

[MK_QSL]

Change your expression as below

sum(TOTAL <PERIOD, [BRAND OWNER]> [Sales Volume 1000 Kgs/Ltrs/Pcs])

[Gysbert_Wassenaar · Accepted solution]

Disable the option Relative and change the expression to:

sum([Sales Volume 1000 Kgs/Ltrs/Pcs])/sum(total <[PERIOD]>[Sales Volume 1000 Kgs/Ltrs/Pcs])

See attached qvw.

[#4]

thanks!!!

[#5]

Hi Sigitas

here it is

it is better not to use keys (PERIOD) in your graph

best regards

Chris