Bar chart with 3 differents expressions/bars

[#1]

Hello,

I want to do a bar chart with 3 bars per year (like : All Sales, Sales for 3 departements and Sales for 5 departements) and 2 dimensions (Years and months).

My problem is with the expression. I have 3 differents expressions for the 3 bars. I don't know how to write my selection in the expression.

Like : Sum( [Sales] & [where departement = (X, Y, Z)] & [where year ='1998 & 1997'] )

If you have any advice or website to give me, please don't hesitate.

Tks for your help.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

This should work

Sum({< Department = {'X', 'Y', 'Z'}, Year = {1997, 1998} >} [Sales])

Hope that helps.

Miguel

[MayilVahanan]

HI,

     Try like this,

     =Sum({< Year={'1998',1997'}>}Sales)

     =Sum({<Departements = {'1','2','3'}, Year={'1998',1997'}>}Sales)

     =Sum({<Departements = {'1','2','3','4',5'}, Year={'1998',1997'}>}Sales)

     Hope it helps

[#4]

It works !

Thank you for your help and your efficacy !