Display only Month-Year Period of the selected Year

[markticoy]

Good day mates !

Here again giving out some question cause I don't really know what to do now.

The case is, I have an accumulative pivot table with Month-Year as one of dimension,

What I want is to only show month-year related to the selected year but the accumulated data will be start from beginning of time in the transaction table.

here is my expression for the chart:

RangeSum(Alt(Before([Comparative]), 0),

sum({$<fMonth=,FiscalMonth=,fYear=,FinancialQuarter=,Month=,MonthNum=,Quarter=,Year=,[Posting Date]={'<=$(vMaxDate)'}>}[VAT Ex])

)

[Gysbert_Wassenaar]

See this document for two possible solutions for your problem: Calculating rolling n-period totals, averages or other aggregations