|
|
#1
06-08-2017, 08:29 PM
|
|||
|
|||
pivot table group by
I have a table with 2 columns, marks, student name.
I also have a sheet with the pivot table that group the marks. Instead of fixing the pivot table group by value, how can I have the group by to use the value that user can set in a particular cells. see attached pic, in this case, I like to group by to use the value entered in cell B1, B2 and B3, instead of having to manually change the pivot table group by value. thanks for helping. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Switch slicer report connections between pivot table and table | tyjulianchen | Excel | 0 | 02-28-2017 04:54 AM |
 Create PIVOT chart using few rows in pivot table
|
Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
| Pivot Table Question- Can the table display in the order the boxes were checked/selected? | blackjack | Excel | 0 | 09-13-2014 08:57 PM |
|
Group Date by Quarter in PIVOT TABLE
|
shilabrow | Excel | 6 | 04-24-2014 10:44 AM |
| Group Table Rows/Column (like Excel Group) | eoinymc | Word | 1 | 03-11-2014 04:51 AM |
Windows 7 64bit 
Office 2013
Linear Mode
