Skip to Content
0
Former Member
Jun 08, 2005 at 02:53 AM

Calculation Help in query - how to get desired results?

22 Views

Example:

Month..Brand..Category ….Amount ..‘Brand Rate’ ..‘Category Rate’

01……1……......a…………….......5…………15………….…..20

01……1…..…a……………..........10…………15………… …..20

01……2……a…………….............5…………5…………….. 20

02……1……a……………............40…………60……………..40

02……1……b……………............20…………60…………….. 120

02……2…… b……………...........70…………100…………….. 120

02……2…… b……………...........30…………100……………..120

I need help with calculation of Brand rate and Category rate

In above example, Month, Brand and Category are characteristics, and amount is a key figure(transaction data)

Brand Rate and Category Rate are calculated key figures (or formula) from the data described above

Brand Rate = Sum of amount (KF) for unique month and Brand ( in other words Total amount for brand for the given)

Category Rate = Sum of amount(KF) for unique month and Category ( in other words Total amount for category for the given)