How can i create a pivot table off this info to show every day of the week once ONLY and subtotals for each day?
Capture.JPG
How can i create a pivot table off this info to show every day of the week once ONLY and subtotals for each day?
Capture.JPG
You have what is called a "Cross-tab" table. To convert it to a database that will allow you to create a pivot table the way you want, follow these instructions:
Press Alt-D, P to get to the secret pivot table wizard that’s different from the one you get from Insert > Pivot table.
Choose Multiple consolidation ranges. Click Next.
Choose I will create the page fields. Click Next.
Select the range and add it. Go through the rest of the wizard to create a pivot table.
Double-click on the Grand-Grand Total (lower right cell of the pivot table).
And then the table that is created will work the way you want...
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks