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 |