1 Reply Latest reply on Jul 2, 2018 1:20 AM by Mahfooj Khan

    How to change bins to compare 1st, 2nd, 3rd across categories

    Alex Martino

      I have bins created and shown by category. How can I show the category percentages BY BIN, so all the 1's compared to each other for the different categories, And then all the 2's and so on?

        • 1. Re: How to change bins to compare 1st, 2nd, 3rd across categories
          Mahfooj Khan

          Hi Alex,

           

          Step 1: Create a calculated field using below formula

           

          {FIXED [Profit (bin)],[Category]:COUNTD([Order ID])}  //Use your own BIN instead of [Profit(bin)]

           

          Step 2: Now drag the field like this. Apply quick table calculation ("Percent of total) on your measure.

          after applying table calc you'll get this view

           

          Step 2: Now address the data partition like this.

          and bingo

          Hope this help. Let us know if you've any question. workbook v10.5 attached for your reference.

           

          Mahfooj

          1 of 1 people found this helpful