Forum Discussion
Solved
Pivot Table
Hello, I have tried to watch videos and have had no luck on turning this data in to a pivot table I need. I have attached the workbook and an example of what we have already for a different set o...
After clicking anywhere in the pivot table, I activated the Design tab of the ribbon.
In the Layout group, I selected Show in Tabular Form from the Report Layout drop-down.
What do you think of the new pivot table in the attached version?
It's perfect, than you! I have been trying to learn how to do that but I could never figure it out. Any recommendations on where to learn?
- How did you get the dates to stay the same ex. 8/1/2023. Every time I add it to the pivot table, it only gives me the month (Jan-Dec).
Sometimes Excel groups dates in a pivot table automatically.
Right-click any of the dates in the pivot table, and select Ungroup... from the context menu.