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:
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.
You will likely need to use a WINDOW_COUNT(Aggregation).
I was not able to view your workbook, as it did not contain the datasource.
You will need to export your workbook as a twbx and repost: