We have a need to create a custom sort order for columns in a pivot grid. (It's more like creating a Column Order rather than a Sort.) For example, the columns are Size and the (Header) values are "S", "M", "L", "XL", "XXL" and the columns need to be displayed in this order. The Row values would be the quantity for each size. And to add a twist, the "Size" values are dependent on the product. For example, a different product would have Size values of "S/M", "M/L", "L/XL". So this functionality would need to be dynamic.
Is this possible?