How to calculate the Sum of Daily Average value for a selected Period

I want to calculate sum of the average daily value off each product.

My dxp  and csv file is  uploaded in below.
My equation is "Sum(Avg([Stops Time(s)]) OVER (Intersect([Product],[Date])))OVER ([Product])".

I get the Average of Each Product for each day. But when I try to get the sum of each day's average, It sums up all the averages in the column.

Any Idea?
Your help is really appreciated.
Thank you.


Binary Data product_-_sheet1.dxp243.29 KB
File product.xlsx9.09 KB

(2) Answers