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.

Attachments

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

(2) Answers

Login