Hi everyone,

I am trying to calculate the average in the pivot table, if the row value is less than or equal to the current row value.

My goal is to understand how long the time is on average up to to a certain day in the month. I would like this to be in a pivot table so I can slice by Region.

Attached is an example workbook. My desired values can be found in Column B on Sheet2.

Is there any way to do this?

Thanks in advance for your help!

Book1.xlsb