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.
how can i do this.
Please provide me suggestions.
Hi PRRAJENDRAN ,
in sort tab use load order reversed and in dimension limit tab show only first 3 values
View solution in original post
In the dimension limits tab, try to impose onle the max 3 months.
Create MonthName field in Script using
monthname(date#(Month,'MMM YYYY')) as MonthName
Create the Pivot Table
You can modify your expression as per your logic