2 Replies Latest reply on Feb 14, 2020 9:48 PM by Mahfooj Khan

    Stacked bar chart

    Yue Xin

      Hi all,


      How do i stack only the "Jeff" and "amount unknown" into one stacked bar chart and leave "Odie'"s separated.



        • 1. Re: Stacked bar chart
          Robert Breen

          Hello Yue,


          I replicated your question with sales data. See attached.

          You can use a calculation like this to group the dimensions together.


          case [Category]

          when "Furniture" then "One"

          when "Office Supplies" then "One"

          when "Technology" then "Two"



          Hope this helps! See attached.

          Please mark this answer as correct or helpful if it solves your question.




          Robert Breen



          • 2. Re: Stacked bar chart
            Mahfooj Khan



            Seeing your screenshot I'd suggest you need to transpose your measures from columns to rows so that all the measures come under one field. Then you can create a group to achieve the expected output.


            Let us know if this helps.