2 Replies Latest reply on Mar 10, 2017 8:32 AM by Jeremy Bartz

    Show all Sales on a Filtered List

    Jeremy Bartz

      Hello.  I have a report where on one sheet I want to show sales by Customer.  When I click on a customer I want to bring up all of their suppliers.  However I want to see what the customer bought and then all the total supplier sales as well.  I was trying to use the LOD Exclude but that isn't giving me what I need.

       

      Example.

      Customer A has 80 Suppliers.

      I want to see the list of 80 suppliers, then first measure is  Customer A sales, next measure All Sales.  I will also need the ability to drill down as needed.  So will need to see all Items the Suppliers sold as well.