Forum Discussion
Update matrix to show total and average columns
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!
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.
3 Replies
- PijushRoy
Community Champion
Anonymous
Can you please share both screenshot as well 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.
