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)