Hi Guys,
I have a pivot table (based on a 50k rows of data), i put one column (date)
in the Filter section of the pivot, but when i click the filter it shows individual
dates unlike in regular excel file which groups the date all dates by months,
year...this is my problem if i select the filter to choose only the dates i want
to show, i had to individually pick them one by one.
is there a way to make it look like a regular filter?
Thanks,
chico
Bookmarks