group information user defined dynamic table in excel 2013
Posted on 2013-12-20
how i can to group information in excel user defined in dynamic table.
I have a pivot table with the source mysql database and I have a field called buffer
I need group by ranges so
between 0 and 33,9 -> green
between 34 and 66,9 -> yellow
between 67 and 100,9 red
greater than 101 gray
are many records
excel only you can group a range, but I have every range that is different
excel to have a origin of a database the records of PivotTable increase and decrease
is not constant
I can group rows in excel and then selecting the group and give the name to the group but the problem is that many records and change records. increase and decrement, so selecting it has a limit in the selection.