Bar chart how to display sales amount and % contribution in QS

[paulyeo11]

Hi All

I have a Bar chart , i like to display 1 Bar show the sales amount , and below the bar show the % contribution.

In QV i have use the same expression , just tick on relative. it will work.

But in QS i am unable to make it.

Paul

[paulyeo11]

my QVF

[#3 · Accepted solution]

Try:

Sum(MeasureName)/Sum(TOTAL MeasureName)

This should give the relative percentage split.

[paulyeo11]

Hi Pravesh

Thank you very much for your help.

Now the % amount indicate in between the 2 Bar , it is possible to set so that % not display between the 2 Bar ? and % display below the % , so that all Bar can be close up and make my chart not so wide.

Paul

[paulyeo11]

Hi Pravesh

In QV it mean set to "Text on Axis"