query to place subtotal over detail data
Good evening. I have a requirements to output into a text file but the subtotal is placed on top of the detail data.
I already tried using union but it still didn't work.
Is it possible to do it in a query.?
example output.
10 15 50
3 5 25
2 5 20
5 5 5
Rey
I already tried using union but it still didn't work.
Is it possible to do it in a query.?
example output.
10 15 50
3 5 25
2 5 20
5 5 5
Rey
0