!@@Hi Team,
we have a below requirement
| Region | Channel | 17-Jul | 17-Jun |
| South | Channel1 | 0 | 18 |
| West | Channel2 | 12 | 5 |
| East | Channel3 | 13 | 7 |
| NorthEast | Channel4 | 18 | 6 |
| North | Channel5 | 19 | 3 |
| Total | 62 | 39 |
Total is nothing but Sum of Jul-17 and Jun-17 aggregate.
The requirement is to show the Total somewhat like below
| Region | Channel | 17-Jul | 18-Jun |
| Total | | 62 | 39 |
| South | Channel1 | 0 | 18 |
| West | Channel2 | 12 | 5 |
| East | Channel3 | 13 | 7 |
| NorthEast | Channel4 | 18 | 6 |
| North | Channel5 | 19 | 3 |
Please note, we tried using partialsum, that failed when there are null values or missing valus, whole data becomes null in that case. Could you please see if that is feasible.
