Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try something like this
IF(Period1 = 'MTD', SUM(SalesForecast))
Or
Use calucauted dimension
=If(Period1 = 'MTD', 'MTD', Period1)
Measure: =If(Period1 = 'MTD', SUM(SalesForecast))