How to display single sales and total sales in one chart?

[ingoniclas]

I am trying to display the sales of store A, store B, and the total of both together in one chart, see below. How can I do this?

Thanks,

Ingo

[Clever_Anjos]

Create two line graphs, (one with Store as dimension and other without)

Set them to same position, set one graph background to transparent

[kkkumar82]

Hi ,

Create three expressions in the chart without Dimension like

Sum({<Store={'A'}>} Sales  - Expression 1

Sum({<Store={'B'}>} Sales  - Expression2

Sum({1}Sales) - Expression3

Thanks

Kiran Kumar

[#4]

is it safe to assume store and date are dimensions?

waht about add date as your dimesnion and have your expression be sum of sales by store using set analysis

the total would be a second expression and could be an aggregate of the 2 or if it is just A and B, you can have this expression be sum of A + sum of B (take your 2 set analysis expressions)

can you send a qvw or data model

[hic · Accepted solution]

On the tab "Dimension limits" you can check "Show total" for your Store dimension.

HIC

[Clever_Anjos]

hic, illuminating as usual

[#7]

looks like Kiran types faster than me - I would suggest his syntax and use the date field for the diemnsion - this will give you your 3 lines like your example

[nizamsha]

Hi

if i want to do mean  then i will go for henric way check weather is working for u i tested for me its working

month and store as Dimension

sum(sales) as Expression

then go to the dimension Limit Tab and click store and check Show total