Adding a separate measure only to a part of one dimenssion

[AdrianS1]

Hi, i have a combo chart with one dimension(Period1 WTD,MTD,YTD) and 2 measures on it. I want to add third  separate measure but only to 'MTD' Dimension.

Can i do this ?

Im thinking about sth like this in adding measure  if(Period1='MTD', 'measure') but its not working.

In general I want to have 2 measure for one dimension (Period1) and 3 measures to each of three parts of my dimension(Period1 WTD,MTD,YTD)

My measure is SalesForecast

Any ideas?

[Chanty4u]

Try something like this

IF(Period1 = 'MTD', SUM(SalesForecast))

Or

Use calucauted dimension

=If(Period1 = 'MTD', 'MTD', Period1)

Measure: =If(Period1 = 'MTD', SUM(SalesForecast))