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.
Your help is really appreciated.