AnsweredAssumed Answered

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

Question asked by egbaumier on May 26, 2014
Latest reply on May 26, 2014 by egbaumier

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

FM13 Pro Advanced

Outcomes