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?Daily Store Sales - Metrics - for excel guru - Copy.xlsx