How to add an average to a matrix without using a measure - I've seen it but can't find it now

[Gameplayer13905]

Hello all and thanks in advance. A coworker showed me the other day how to add an average to a matrix or table and now I can't find it. She right clicked on something and a column of choices appeared which showed Sum, Average, etc. Anyone remember where this is?

Thanks again

[vicky_ · Accepted solution]

It's on the Right hand side where you put the data. However, you won't be able to see it if you're trying to get the average of a measure - it will only show up if you use a numeric type column

[Gameplayer13905]

Thank you Vicky_, will this work across a series of months? I have a table with columns like this

Jun_23

Jul_23

Aug_23

Sep_23

I am trying to get an average of the four months for each customer. I think what you showed, and it is what my coworker showed me, thank you! - it's the average for all of the data in a given month. Can you give me your thoughts? I'll mark this as solved shortly