5 Replies Latest reply on Sep 22, 2016 10:40 AM by David Li

    How sync rows displayed across two sheets with differing LODs?

    Will Godfrey

      Hi All,

       

      I'm trying to figure out how to get a list of products based on a Geo/Segment filter and then compare this list to a specific customer's products purchased. I'm trying to quickly visualize the delta between a customer segment and a specific customer in terms of product basket.

       

      I can't seem to figure out how to "filter" the data on the customer sheet so that is shows all of the rows of products from the segment, but only numbers for the products that the customer actually purchased.

       

      I've attached a sample workbook with the superstore dataset. Take a look at the "Example" dashboard for a more visual idea of what I want to achieve.

       

      I'm open to any approach to achieve this - I've been banging my head against the wall for two days on it. Love some insight from the community!

       

      Thanks!