4 Replies Latest reply on May 15, 2018 12:19 AM by Prabu Deivendran

    Display Aggregated value in disaggrecation

    Prabu Deivendran

      Hi All,

       

      I need help to show the view based on the requirement. PFA Sample Date and workbook.

        

      I have made an View like below.

       

      Purchase Bucket Calculation : str({ FIXED [Customer ID]:COUNTD([Order ID])})+ ' Purchase'

       

      Purchase bucket# of Customers
      3 Purchase 1
      5 Purchase 1
      7 Purchase 1
      10 Purchase 1
      11 Purchase 2

       

      One customer made three orders in specific date range.

       

       

      Purchas Bucket

      # of Customers

      Expected # of Customers

      3 Purchase

      1

      6

      5 Purchase

      1

      5

      7 Purchase

      1

      4

      10 Purchase

      1

      3

      11 Purchase

      2

      2

      Sum

      6

       

       

       

      Final Output:

       

      Purchas Bucket

      # of Customers

      1 Purchase

      6

      2 Purchase

      6

      3 Purchase

      6

      4 Purchase

      5

      5 Purchase

      5

      6 Purchase

      4

      7 Purchase

      4

      8 Purchase

      3

      9 Purchase

      3

      10 Purchase

      3

      11 Purchase

      2

       

      Regards,

      Prabu