Combo chart to show total gross sales and product wise sales

[sateeshkumar]

Hi,

I have a requirement to show the chart as Attached. Here Total sales is constant irrespective of the selection of Product, But when i select Product that slaes should be shown in line across the bar chart. I am choosing Combo chart with 2 exprssions

Dimensions: Qtr

1expr: used set analysis to fix the product selection for sum(sales)

2Expr:  sum(sales). it will be change based on selection of product field.

But when i select more than 2 product, it is showing sum of these product sales. but i need to show individual lines for each product.

If i get it by overlapping chart, X and Y axis values are changing automatically. so i could not fix it.

Added sample data also

Please help me on this.

[sunny_talwar]

Would you be able to share a sample to play around with this?

[#3]

Can you share your sample data, so that it could help us to give solutions

[#4 · Accepted solution]

Hi plz look into attached app, if it is which you need then sounds gr8

[sateeshkumar]

Hi, I didn't see any Attachment.

[oknotsen]

Open and read the actual topic. It clearly is there.

[sateeshkumar]

Actually i have 3 fields

1.year-qtr

2.product

3.sales

now i want to show total sales on bar's irrespective of product selection

and show the lines as sales of products that are selected.

so i have used below dementions and expressions are

Dimention: year-qtr

Expression:

1) sum({<product=>sales}

2) Sum(sales)

so 1st expression shows total sales in bar's. The 2nd expression shows sales based on selection of product. but if i select 2 products then it is showing as sum of these product sales.

but i want to show different lines for each product.

I tried it by using overlapping charts one for bar and another for lines. but Y-axis values are changing .so please provide the solution to this.