I want to restrict the Dimension values (which has month names like Dec 2018).
I just want use only last two month's names to be used in the pivot table.
I have tried something like this but doesn't work.
BrokerageMonth = MonthName(today())
BrokerageMonth = (MonthName(addmonths(max(today()),-1)))
Could anyone please throw some light on how to achieve so.
Thanks in advance,