Limiting dimension values dynamically in Pivot table

[prathipsrinivas]

Hi Folks,

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.

=if(
BrokerageMonth = MonthName(today())
or

BrokerageMonth = (MonthName(addmonths(max(today()),-1)))
,
BrokerageMonth

)

Could anyone please throw some light on how to achieve so.

Thanks in advance,

Prathip

[prathipsrinivas · Accepted solution]

It's working as expected when I just added aggr.

Now it looks like this:-

=aggr(if(
BrokerageMonth = MonthName(today())
or

BrokerageMonth = (MonthName(addmonths(max(today()),-1)))
,
BrokerageMonth

),BrokerageMonth)

[prathipsrinivas]

It's working as expected when I just added aggr.

Now it looks like this:-

=aggr(if(
BrokerageMonth = MonthName(today())
or

BrokerageMonth = (MonthName(addmonths(max(today()),-1)))
,
BrokerageMonth