Forum Discussion
rsbin
Community Champion
Community ChampionHelp with Matrix Totals....again
Good Afternoon All,
Have searched for a solution for my scenario, but haven't quite been able to arrive at the solution I am looking for. Have the following Matrix:
Achieved using the fol...
yeah, I would go with your two visual approach.
rsbinCommunity Champion
Community Championlbendlin ,
Thanks for the response. Yes, I should have included some sample data.....
| Department | All Time Worked | MonthName | Year |
| A | 640 | January | 2022 |
| A | 1184 | January | 2023 |
| A | 616 | February | 2022 |
| A | 1112 | February | 2023 |
| A | 456 | March | 2022 |
| A | 832 | March | 2023 |
| B | 1804 | January | 2022 |
| B | 2011 | January | 2023 |
| B | 1903 | February | 2022 |
| B | 1896 | February | 2023 |
| B | 1362 | March | 2022 |
| B | 1133 | March | 2023 |
| C | 2151 | January | 2022 |
| C | 2168 | January | 2023 |
| C | 2122 | February | 2022 |
| C | 2103 | February | 2023 |
| C | 1762 | March | 2022 |
| C | 1486 | March | 2023 |
| D | 1411 | January | 2022 |
| D | 1210 | January | 2023 |
| D | 1251 | February | 2022 |
| D | 1113 | February | 2023 |
| D | 1024 | March | 2022 |
| D | 769 | March | 2023 |
The actual data is at the Employee Level by Day, but think providing summary data should suffice.
I am connected to a Calendar Table where I use a Flag to filter Calendar Days for PriorYear and CurrentYear.
What I am looking for is a way to show only the two Annual Totals in the same Visual as the Monthly values.
The closest I have got so far is to show as two separate Matrix visuals.
Thanks again and appreciate any guidance you can provide.
lbendlin
Super User
Super Userwhich two annual totals are you referring to?