Link to home
Avatar of developingprogrammer
developingprogrammer

asked on

pivot table report filter grouping

hey guys i want to group the date of one of my pivot table fields. i know how to group it if its in the rows or columns place, but i don't know how to group it if it's in the report filter place. i've attached the picture below, it's showing me individual dates of dec and nov. i want to be able to choose "DEC" or "NOV" or whichever other date it is. could yall help me out? not sure if this is possible or not. thanks guys!!User generated image
(maybe i have to create one more column showing the month(A2) for example - but if i have to resort to that, how do i show "mmm yyyy" format from the list that the user selects from? i know i can format the cell to show "mmm yyyy" but that only shows that format after the user selects 1/12/2012 from the value list.User generated imageUser generated image
so in the end i used the text formula text(a3,"mmm yyyy") for the work around solution which gave me the right formatting, but how do i sort it in the value list as a sequential months instead of alphabetical order? thanks guys!!
SOLUTION
Avatar of terencino
terencino
Flag of Australia image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of developingprogrammer
developingprogrammer

ASKER

ok guys let me try it and get back to yall. so sorry for the super late response!!!!
will try this next week guys, sorry for the delay!!
thanks guys for your help!! appreciate it!! = )))