i have a table with 3 columns
quantity, x, y
and im trying to make summary of rows which have same indexes in X and Y
and sort by those indexes.
I MEAN FOR EXAMPLE
QUANTITY--X---Y-------->-QUANTITY---X---Y
-----3-------A---B------->--------5------A---B
-----2-------A---A------->--------2------A---A
-----2-------A---B------------------------------
didnt manage to solve it in pivot charts
Bookmarks