how to show only total in Bar chart

[#1]

Hi,

Could anyone let me know is it possible to show only Total bar instead of all bars for a month data. for more clarification I am attacing my Bar chart.please could anyone help me as my user wants to see only total data.

Thanks.

[#2]

you can use TOTAL in your expressions...

for example:

Sum(TOTAL Sales)

or

sum(Sales)/sum(total <Month> Sales)

[#3]

Please could anyone help me as it is urgent please help

[#4]

how to use SUM  as I need to use  expression like below.

count

({<Result={'Fail'}>} distinct Reference)/Count(Distinct(Reference))

please help

[#5]

I have to consider % of Failures so I need to use

count

({<Result={'Fail'}>} distinct Reference)/Count(Distinct(Reference))

so when I am using SUM it is showing error. In this case please tell me how to use SUM

[christophebrault]

Hi,

In the Style tab of your chart, check Filled instead of Grouped

[#7]

Thanks for this.

But my user wnats to see only the total bar

[#8]

Could you please help how to select this

[#9]

Please help

[Anonymous]

Amelia

From your attached *.docx it looks as if you have more than one dimension on the bar chart, you may well only need a single dimension.

Although to be honest I am a bit unsure as to what you are actually trying to achieve. Could you post a picture of what you want to display and what your current dimensions & expressions are [ or the qvw].

Best Regards,     Bill Markham