Share
ReportHi all,
I have a requirement where I need to hide row group and column group based on Group totals. The matrix is grouped on Resource and Project for Row Group and Column Group is on Every Week's Monday. Additionally, Group total is an expression: Work Hours in Week - Bookable Resource Bookings Hours in Week. E.g: In the table below, For Resource A, in 3rd March 2018 Week, total will be 40-(24+8)= 8
I want to show data only when the Group total is a negative value. In the table below, I want to hide/ remove Resource A Group since there is no negative Totals value in the specified date range
Same for Column visibility, column with negative values needs to be displayed. In the table below, I want to hide/remove Column 03-20-2018 since there is no negative Totals value in the specified week.
| Resource | Project | 03-06-2018 | 03-13-2018 | 03-20-2018 |
| A | ABC | 24 | 24 | 24 |
| A | XYZ | 8 | 0 | 0 |
| A | LMN | 0 | 0 | 0 |
| Total | 8 | 16 | 16 | |
| B | ABC | 8 | 0 | 0 |
| B | XYZ | 8 | 32 | 8 |
| B | LMN | 0 | 32 | 0 |
| B | PQR | 20 | 0 | 0 |
| B | DFG | 20 | 32 | 0 |
| Total | -16 | -56 | 32 |
Any suggestions on how to achieve this.
*This post is locked for comments
All responses (
Answers (
2,678
