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.
|