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

    Sorting by Sales stacked bars




      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 -



      Thx for Help!