Update matrix to show total and average columns

[Anonymous]

Greetings all,

I have a scenario where I need to only show the number of balls on a given date. I'm currently using a matrix and ideally I would want the daily totals, grand total for the selected days, and average total for the selected days to be displayed. 

As you can see below, the average column is being populated for each day. But I only want to see the average for the selected range. How can I achieve this?

Rows: Ball type, ball model

Column: Date

Values: Count of balls by day, Avg Num of balls by day

Current state:

Ideal state:

Thank you in advance!

[Anonymous · Accepted solution]

Hi  @Anonymous ,

You can use the following way:

1.Adjust the width of the unwanted [Measure] to hide it in the matrix

2.  You can also consider to create a custom column time table to replace original table fields, then write measure to use the current row and column to search corresponding results.

For example:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

@Anonymous 

Can you please share both screenshot as well

[Anonymous]

Updated.