# 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.

+ Add a Comment