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.
9 Replies
Hi brunohelder ,
If you need to show the quarterly average, you can change sum to average. if you need to add a column, you can check the following results:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much for the reply.
I could not get it to work.
Your example has a table with date and the number amount for the date.
In my source table each entry is a line with a date and the quantity is 1 (one observation). The screenshot that I have sent is a count of the lines by date (Date Hierarchy). If I do an Average I get 1.
Hi brunohelder ,
Can you provide sample data, so that we can better solve the problem for you.
Best regards,
Community Support Team_ Scott Chang
