4 Replies Latest reply on Jun 6, 2016 3:29 AM by John Sobczak

    Sorting by Sales stacked bars

    Yakis Yak

      Hey,

       

      I have a problem which I bet is banal but I can't deal with it. I have sheet with bar chart with sorting by sub-category by sales ascending. When one year is selected its work properly, but when i select for example two years. Sorting does not work properly, because sales are sum for all years. I have tried contaminate dimension to sorting, but then i have to many colors to set for many years screen 3.

       

      1. One year

      2. Two Years -

      3.

       

      Thx for Help!

      Regards