7 Replies Latest reply: Nov 16, 2017 3:30 PM by sam pusala RSS

    Top Customer vs Top Products

    sam pusala

      I am planning to achieve below 4th table for Top Customer vs Top Products.

      Example:  have simple below 3 table charts results for sample Inline data added bottom.

      All data in simple tables:

      Expected result:

      sample data:

       

      custTable:
      Load * Inline [
      customer, product

      'abc', 'p1'
      'abc',  'p1'
      'abc',  'p1'
      'abc', 'p2'
      'abc', 'p3'

      'pqr',  'p1'
      'pqr', 'p2'
      'pqr',  'p2'
      'pqr', 'p3'

      'xyz', 'p5'
      'EEE', 'p1'

      ];