Restrict Month

[#1]

Hi Experts,

I have a Month field which is from Jan 2015 till Aug 2015

I need to add this dimension into a pivot table.

But I need to restrict it to 3 months. i.e., i need only June 2015 to Aug 2015 to be added to the Month field in the table not in the script.

     Actual                                 Requirement

        

how can i do this.

Please provide me suggestions.

[jduarte12]

Hi,

In the dimension limits tab, try to impose onle the max 3 months.

Regards

[Kushal_Chawda]

Create MonthName field in Script using

monthname(date#(Month,'MMM YYYY')) as MonthName

Create the Pivot Table

Dimension:

MonthName

Expression:

Sum({<MonthName={">=$(=addmonths(max(MonthName),-2))<=$(=addmonths(max(MonthName),0))"}>}Sales)

You can modify your expression as per your logic

[gautik92 · Accepted solution]

Hi PRRAJENDRAN ,

try this

in sort tab use load order reversed and in dimension limit tab show only first 3 values