1 Reply Latest reply on Aug 10, 2018 7:19 PM by swaroop.gantela

    Comparing distinct count of document in periods

    Benjamin Rubattel

      Hello Everyone,


      I am building a group performance Dashboard which will contain


      -> total Sales Orders Lines

      -> Total Sales Order Header

      -> On Time Delivery

      -> Inventory Availability

      -> Billing Value


      I wish to report the volumes on and value (Sales order Lines/Header and Billing) as per below:


      • Total_PY_Volume (Total number of transaction in previous year)
      • YTD (Start of this year todate)
      • YTD-1 (Start of previous year todate-1 year)
      • % Change
      • Trendline



      I have started to build this for the sales order line volume and I get the result I need but I am struggling to calculate the Total_PY_Volume of Distinct **** of Sales orders.


      I am using the same calculation as I used for the Line Orders but it doesn't accept I put a COUNT(aggregation)


      See work book attached. If anyone as an idea on how i could do would be great.