Forum Discussion
Display the quarterly average on a Matrix
I have a matrix that is counting the rows of a table by month of activity. I would like to add to the right the quarterly average of the activity.
Hi brunohelder ,
Because in my expression I fixed that there are three months in a quarter, even though there is no value.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
It seems to be related to the "FILTER (ALL" that you have.
If I remove the ALL from your formula it changes:
But if I Keep the Filter ALL on my formula it disregards others filters that I have and that I need.
Hi brunohelder ,
Change ALL to ALLSELECTED to try it out
Best regards,
Community Support Team_ Scott Chang