Forum Discussion
Show 2 Total Values in a matrix table
I have a matrix table which is currently showing a count of ID as value with team name being rows and Sprint # being Column, I want to add a dynamic average to this which changes based on the sprint # that have been selected I have the formula all done the issue is i want the dynamic average to only be shown as a total not combined with the id count for the sprints, an example of what i am getting is attached below and my goal is to have the same table but instead of showing ID Count and Dynamic Average for each sprint it only shows ID count for the Sprint E.g. S3 but for Total it shows the ID count and Dynamic average as is shown on the photo. is this possible?
Many Thanks
1 Reply
- Greg_DecklerCommunity Champion
Anonymous Generally not straight forward to do this, see this:
The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community