2 Replies Latest reply on Aug 15, 2018 11:35 PM by Mahfooj Khan

    Enlist all products, 80% of total sales per manufaturer

    Patrick Weber

      Hi everyone. I have an issue:

      Let's say we have  sales, manufacturer, products and sales date together in a table.

       

      Now we are able to find sales per manufacturer of a certain year or for several years.

       

      How I'm able to entlist products for each manufaturer which contribute nearly 80% of sales per manufacturer?

       

      I attached a screenshot: In this case you can see that ProdA,B and E are 80% of total sales for the manufacturer "Good Things".

      Now we only want to see the yellow marked lines.

       

       

      Is there an easy way if you have a bunch of manufacturer and products?

       

      Thanks for any hints.

        • 1. Re: Enlist all products, 80% of total sales per manufaturer
          David Maning

          Hi,

           

          There is a miss of logic in your statement.

          Example:

          a - 5

          b - 1

          c - 1

          d - 1

          e - 1

          f - 1

           

          So how do you choose groups to determine 80%?

           

          However in someway in is still possible.

           

          Calculation:

          IF RUNNING_SUM(SUM([Sales]) / TOTAL(SUM([Sales]))) <= 0.8

          THEN 'Show'

          END

           

          You can sort your dimension according to metric in descending order.

           

          Example is in the attachment.

           

          Trust this helps.

          D

          • 2. Re: Enlist all products, 80% of total sales per manufaturer
            Mahfooj Khan

            Hi,

             

            This is called Pareto chart

            • Drag Product field in columns shelf

            • Drag sales measure in rows shelf

            • Sort the products in descending order based on sales measure

            • Now apply quick table calculations

                Primary calculation type: Running total

                Secondary calculation type: Percent of total

            Once done then create a calculated field to highlight the products met the 80% of total sales target or you can use constant reference line like this

             

            80% of Total Sales:

            RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales]))>0.8

            Finally you'll get something like this.

            Let us know if this help. Workbook v10.5 attached for reference.

             

            Mahfooj

            1 of 1 people found this helpful