Short By Columns

[BrianEstVal]

Hi there,

I'm trying to solve a problem with the order by column. I have row with the articles and a columns with the stores and i need to order by the max values  of unity sales. FOr example, if i click in one store the unity of sales would be order by max desc order and if i click another one the unity of sales would be order by max desc order, that is all. But is so difficult because the matriz it's be order by the max unity of some store. Some idea?