pivot table with custom dimention and month

[sateeshkumar]

Hi,

i am facing an issue with pivot table. I have one inline and also have year_month as dimention. So i want pivot table with last 6 months data. whereas each row in inline column having different expression. When i tried to develop this by using pick(match...) condition, it is displaying only latest month.All other months having null values.

below is my expreesion for one row.

pick(match(dim_1,'value1','value2',...),

Only({<Date={"<=$(vMaxDate)>=$(vMin6month)"}>}metric1),

Only({<Date={"<=$(vMaxDate)>=$(vMin6month)"}>}metric2)...)

So please help me to solve this issue.

Thanks

[sunny_talwar]

Have you made any selection in the month field?

[sateeshkumar]

Yes, I have filter for Month,But I am restricting it in Expreesion like below.

pick(match(dim_1,'value1','value2',...),

Only({<year=,month=,Date={"<=$(vMaxDate)>=$(vMin6month)"}>}metric1),

Only({<year=,month=,Date={"<=$(vMaxDate)>=$(vMin6month)"}>}metric2)...)

[sunny_talwar]

May be try this

Pick(Match(Only({1} dim_1),'value1','value2',...),

Only({<Date={"<=$(vMaxDate)>=$(vMin6month)"}, Month>}metric1),

Only({<Date={"<=$(vMaxDate)>=$(vMin6month)"}, Month>}metric2)...)

[sateeshkumar]

Tried, but No luck

[sunny_talwar]

Would you be able to share a sample?

Preparing examples for Upload - Reduction and Data Scrambling