Loacation Name Sales Comm
252 ABC 100 12.5
252 CCC 100 12.5
252 DDD 100 12.5
300 EEE 100 12.5
300 FFF 100 12.5
500 GGG 100 12.5
500 HHH 100 12.5
500 KKK 100 12.5
Is there any way to get the subtotal and running/cumulative total in each change of location number as under:
Loacation Name Sales Comm
252 ABC 100 12.5
252 CCC 100 12.5
252 DDD 100 12.5
252 total
Cum total
300 EEE 100 12.5
300 FFF 100 12.5
252 total
Cum total
500 GGG 100 12.5
500 HHH 100 12.5
500 KKK 100 12.5
252 total
Cum total
Grand Total
252 ABC 100 12.5
252 CCC 100 12.5
252 DDD 100 12.5
300 EEE 100 12.5
300 FFF 100 12.5
500 GGG 100 12.5
500 HHH 100 12.5
500 KKK 100 12.5
Is there any way to get the subtotal and running/cumulative total in each change of location number as under:
Loacation Name Sales Comm
252 ABC 100 12.5
252 CCC 100 12.5
252 DDD 100 12.5
252 total
Cum total
300 EEE 100 12.5
300 FFF 100 12.5
252 total
Cum total
500 GGG 100 12.5
500 HHH 100 12.5
500 KKK 100 12.5
252 total
Cum total
Grand Total