Hello,
I do have below data
Order Line Amount
A00001 10 $60
A00001 20 $40
A00002 10 $20
A00003 10 $80
Added new formula to calculate % based on Amount, this percentage should equally distribute.
Order Line Amount %share
A00001 10 $60 %60
A00001 20 $40 %40
Subtoal $100 %50
A00002 10 $20 %20
A00003 10 $80 %80
Subtoal $100 %50
Overal Result$200 %100
I want to show subtotals in below format.
Order Line Amount %share
A00001 10 $60 %60
A00001 20 $40 %40
Subtoal $100 %100
A00002 10 $20 %20
A00003 10 $80 %80
Subtoal $100 %100
Overal Result$200 %100
This is just example, please advice how i can show the subtotals
I tried using SUMCT and %CT but they are not showing %100 for Order A00001, which I want to.
Pls help,.
Angelo