Adnandos
New member
- Joined
- Jun 12, 2018
- Messages
- 25
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 365
Hi all
I have a non-standard table that we've drafted. The purpose of the table is to track sale numbers by store, category, and date.
In an ordinary table, creating a pivot and grouping is easy. However, because I have my dates running across as columns in my source table, the Pivot table is acting up a bit, and is showing each date as a separate field to choose from.
Ultimately we're looking for a pivot table that will show as rows (store, then metric), and as columns, months, where the values presented in the table is the sum of the relevant metric.
How can we go about doing this?View attachment Daily Store Sales - Metrics - for excel guru - Copy.xlsx
I have a non-standard table that we've drafted. The purpose of the table is to track sale numbers by store, category, and date.
In an ordinary table, creating a pivot and grouping is easy. However, because I have my dates running across as columns in my source table, the Pivot table is acting up a bit, and is showing each date as a separate field to choose from.
Ultimately we're looking for a pivot table that will show as rows (store, then metric), and as columns, months, where the values presented in the table is the sum of the relevant metric.
How can we go about doing this?View attachment Daily Store Sales - Metrics - for excel guru - Copy.xlsx