4 Replies Latest reply on Nov 15, 2018 8:00 AM by Amar Amar

    How to do legends with stacked bar and single color for the attached workbook?

    Amar Amar

      Hi,

      I'm trying to achieve one use case, attached the workbook.

       

      When i select show which is ship mode as the parameter, when i select First Class , then show only First class sales which i achieved, when i select Same Day , it is showing same day sales, and where i struck is  two things:

      1) when i select First Class Same Day from the parameter, in the same worksheet I need to show sales by color legend (basically stacked bar chart) .

      2) when i select Total from the parameter... it should show Total combined sales for First class and Same day but in same color (may be let us take Green)

       

      From the parameter , when i select:

      First class:

      Blue legend with sales

       

      Same Day

      Orange Legend with sales:

       

      First Class Same Day

      Need to achieve Combined sales ( FIrst class and Blue Legend) in stacked color legends Blue and Orange.

      and lastly

      when i select Total from the parameter, it should legend for Total and combined sales for First class and Same Day in same color.

      Please let me know .