Pivot Table with Measures as Rows

[imrasyed]

Hi Experts,

I have a pivot table with Measures as Rows.When I add a Dimension as a Row ,It is displaying the entire data set values instead of showing for that particular measure.

Ex:

I have a Measure  Last Year full Month for which the Dimension values should show till 11/24/2017  but it is also showing 2018 dates as well.And it is becoz I have one more measure MTD Current Year so it is considering all the Dates.How can I show Dates corresponding to that measure?

Thanks

syed Imran 

[Anil_Babu_Samineni]

Initially the expression should be work

Sum({<DateField = {">=$(=Date(MonthStart(Max(DateField))))<=$(=Date(MonthEnd(Max(DateField))))"}, Year=, Month, Week=>} Sales)

[imrasyed]

Yes I used the same expression but still the other dates are populating.

Sum({<Date ={">=$(=MonthStart(AddYears('$(vMaxDATE)',-1))) <=$(=(AddYears('$(vMaxDATE)',-1)))"}>}sales)--Last year full month

And for MTD Current year :

Sum({<Year={'$(vCurrYR)'},MonthNo ={'$(vCurrMn)'}>}sales)