|
|
#2
02-28-2023, 03:27 PM
|
||||
|
||||
This is because you're pivoting data which is essentially already pivoted!
In the attached is: 1. An ugly workaround added to your existing which is a calculated field. Don't use it, it's very inflexible (and it doesn't change if you add/remove things to the values area). 2. A second pivot at cell O3 which works as I think you want. It's your data, unpivoted by Power Query in the background and a new pivot table created from the result. In the background your data is transformed to look like this: 2023-02-28_222447.png 
|
| Tags |
| column totals, date filtering, pivot table |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot totals / subtotals | ProudLiberal | Excel | 0 | 03-20-2020 06:04 AM |
| Pivot table- % growth and difference between two items in same column by months | sarana | Excel | 2 | 01-28-2019 06:42 AM |
| Excel pivot table | Don Harrison | Excel | 6 | 06-07-2017 02:32 PM |
 How do I get column titles to show up in my pivot table?
|
nrcahill | Excel | 3 | 03-07-2016 09:35 AM |
| Pivot table with numbers as column headers | kezhia_0128 | Excel | 0 | 08-28-2014 12:48 PM |
Windows 10 
Office 2019
Threaded Mode