2 Replies Latest reply on Aug 19, 2018 3:30 PM by Chris McClellan Branched from an earlier discussion.

    How to find how much the product contributes to a specific group's sales

    Curious Wolf

      Hi Chris McClellan,This is a continuation of the previous question.The requirement is to see  if the product is driving its own parent store's sales up or down.The two axes are the Parent store's total sales and the Product's sales.

      I have already used include lod in the calculation as the sales is to be derived per product name,so not sure how to fix the level of detail to Store.

      I have attached the sample workbook.Any help on this is much appreciated.Thanks