Hi, I’m trying to group display on treemap chart based on column name. All I need to do is sort the data table so that the column I want to group is grouped by the data on that column, right?
For example I have original table:
NAME BRAND PRICE
A 10A5 41.69
A 11A5 52.15
A 10A5 47.51
B 10A6 22.69
B 11A6 32.56
B 10A6 27.34
A 12A5 36.86
A 12A5 50.23
A 11A5 45.67
B 12A6 46.86
B 12A6 30.57
B 11A6 35.67
B 10A6 37.45
B 11A6 37.57
B 10A6 40.5
The table I need to transform into to group the data:
NAME BRAND PRICE
A 10A5 41.69
A 11A5 52.15
A 10A5 47.51
A 12A5 36.86
A 12A5 50.23
A 11A5 45.67
B 10A6 22.69
B 11A6 32.56
B 10A6 27.34
B 12A6 46.86
B 12A6 30.57
B 11A6 35.67
B 10A6 37.45
B 11A6 37.57
B 10A6 40.5
Thanks a lot.