2 Replies Latest reply on May 26, 2014 11:09 AM by egbaumier

# How to get calculation between 2 fields at 2 level sorted report?

At Report sorted by Month I have:

Customer Order Amount

Acme 100

Drax 140

Pix 160

(Total when sorted by Month) = 400

I need to represent customer share per month, such as:

Customer Order Amount SHARE

Acme 100 25%

Drax 140 35%

Pix 160 40%

(Total when sorted by Month) = 400

SHARE should be Total Amount Order from every Customer sorted by Month / Sum of All Order Amount from a lll Customers at the same Month.

I tried several different ways from Calculation, Summary e Global Field without any success.

Maybe this solution is simple but I couldn’t figure out.

Is there any suggestions?

Regards

Edison

• ###### 1. Re: How to get calculation between 2 fields at 2 level sorted report?

Edison Garcia wrote:

SHARE should be Total Amount Order from every Customer sorted by Month / Sum of All Order Amount from a lll Customers at the same Month.

That's

GetSummary ( sTotalOfAmount ; customer ) / GetSummary ( sTotalOfAmount ; sTotalOfAmount )

that is, if the found set is for a month, and the sort is by customer; if you need these figures within a larger foundset (across several months) that is sorted by month AND customer, try

GetSummary ( sTotalOfAmount ; customer ) / GetSummary ( sTotalOfAmount ; month )

or use both.

• ###### 2. Re: How to get calculation between 2 fields at 2 level sorted report?

Thanks

Worked fine....

Regards

Edison