I am having trouble with my pivot table. Every time I select date due it auto selects years and quarterly. How do I turn the feature off?
I am having trouble with my pivot table. Every time I select date due it auto selects years and quarterly. How do I turn the feature off?
I am new to pivot tables so I don't know if this is right but hopefully it will help.
You can right click on the year or quarter in your pivot table and click ungroup. You can also click group and choose how you want the dates to be grouped. If you want to group by weeks I think you have to select days and then change the number to 7
Can you attach a sample of your pivot table.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks