|
|
#4
07-23-2017, 06:18 AM
|
|||
|
|||
I don't know how to get the pivot table react as you want but you might want to take a look at columns E:G in the attached where I have tried to solve it by means of normal formulas.
I have converted your table in Sheet1 to a range but you can convert it back to a table if you want. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Pivot Table - Problem with grouping data (need help for my example) | klm | Excel | 1 | 07-17-2017 06:20 AM |
 Create PIVOT chart using few rows in pivot table
|
Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
|
Excel 2010 Pivot table problem
|
Kris TenEyck | Excel | 4 | 02-01-2014 01:26 AM |
|
Pivot table grouping problem 2 tables need different grouping
|
differentdrummer | Excel | 3 | 12-10-2013 01:19 AM |
|
Pivot table problem
|
swindon | Excel | 5 | 05-25-2010 02:05 PM |
Windows 10 
Office 2016
Threaded Mode