Hi there! I have a pivote table in my quicksight analyisis with orders per product.
I need to calculate the monthly average so i’ll obtain a table like this:

and then divide this by the count of how many times the value is occurring to get the same result. But actually I believe the functions are mentioning should do the same. How did you write formula? Maybe I can help.