Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Quick question. I have column MONTHNo. I need to get data from those column like 9, 10, 11
I got query for coverage which used some total. I need data from column in pivot to help me scope data each month so that I will get same number 223. my expression below. Please advise.
Sum( {<$(mvLevelItem) , $(mvMeasureTME) , $(mvCHANNEL_GT), $(mvViewPeriod_TY), MONTHNo = {"9"} >} Total CoverageCust )
It's work perfectly. Thank you, but this is a bit difficult for me. Is it possible to explain your expression?
If(Column(1), Only({<$(mvLevelItem), $(mvMeasureTME), $(mvCHANNEL_GT)>}
Aggr(NODISTINCT Sum({<$(mvLevelItem), $(mvMeasureTME), $(mvCHANNEL_GT)>} CoverageCust), MONTHNo)))