How to show 4 expressions in 2 lines using subtype stacked ?

[yanivvl0]

hello everybody ,

we ha a bar chart with 2 expressions : brutto , netto and dim year ,  subtype=stacked ,  look like :

we need to show  brutto , netto  in 2 different calculations that give us 4 expressions ,  so there is a line for each  , something like this :

i am sure there is awy to do it , can you help ?  thanks!!

[Anil_Babu_Samineni]

You can try combo chart with one expression is bar and one more is line. Or else if you are referring different then use style is static instead of group

[adamdavi3s]

Like this?

[yanivvl0]

hi Adam , not exactly , because i have only one dimension , and to be more cleare 4 ( not 2 ) expressions , brutto , netto calc type 1 and brutto , netto calc type 2.    sorry for not writing this before.

[adamdavi3s]

hmmmm can you share some simple data in excel or a qvw? sorry my brain isn't up to speed today!

[adamdavi3s]

Did you manage to solve this one?

[yanivvl0]

hi , here an example of 1 dim and 4 expr ,

i need brutto_1 & netto_1 stacked in one line , and brutto_2 & netto_2 stacked in anothet line ,

thanks !

[adamdavi3s · Accepted solution]

Awesome, it is much easier to work with data that makes sense

Does this work for you?

[yanivvl0]

great help Adam - thanks !!

[adamdavi3s]

No worries at all

If your real world data is more complicated then use Pick(match()) instead of IF as it will work faster, but in this case it will work.