Bar Chart

[d_ankusha]

I want to create a Bar Chart with four bars. There is one Dimension for ex. Date and one measure for ex. Sales. Now in Bar chart first bar shows the sales for current  month. Second bar shows the sales for MTD, third Bar shows the sales for YTD and Fourth bar shows the sales for Quarter year.

Please can anyone suggest a way to do that?

[tresesco · Accepted solution]

Try using synthetic dimension, like:

Dim: ValueList('Curr Month Sales', 'MTD', 'YTD', 'QTD')

Exp: Pick(Match(ValueList('Curr Month Sales', 'MTD', 'YTD', 'QTD'), 'Curr Month Sales', 'MTD', 'YTD', 'QTD'),

          <Exp for Curr Month Sales>, <Exp for MTD>, <Exp for YTD>, <Exp for QTD>)

[d_ankusha]

Thank you