Total Count

[#1]

Hi ,

I am trying to create a bar chart which should display the sales value for each sales person and the total sales.

i have tried by adding the sales person as the Dimesion and added two expression ....One to show the sales for each dimesion and the other to show the total sales. In the graph it is showing two bars for each dimesion one is Overall sales and other is the individual sales amount.

Please suggest is there any way to get the required result

[Anonymous · Accepted solution]

There is no need for 2nd expression - check "show total" on "presentation" tab in chart properties.

[kji]

Well sounds like what you want is to just remove the second expression, and instead select "Show Total" on the presentation tab of properties.

[#4]

Thanks for your response....