Skip to Content
0
Former Member
May 14, 2010 at 06:43 PM

"%CT" want at query subtotals

52 Views

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