how to get subtotals for a column which doesn't have any column that can be grouped with
| ytd |
100 |
| 200 |
| 300 |
| null |
| null |
| 100 |
| 200 |
| null |
| 200 |
| 100 |
Please note that there should be 3 sub totals here
Solved! Go to Solution.
Hi, @syed_shab03
What are you want output?
| Input | Output | |||
| ytd | ytd | Sum_ytd | ID | |
| 100 | 100 | 600 | 10 | |
| 200 | 200 | 600 | 10 | |
| 300 | 300 | 600 | 10 | |
| 600 | 10 | |||
| 600 | 10 | |||
| 100 | 100 | 300 | 60 | |
| 200 | 200 | 300 | 60 | |
| 300 | 60 | |||
| 200 | 200 | 300 | 90 | |
| 100 | 100 | 300 | 90 |
