Former Member

# Calculation Help in query - how to get desired results?

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)

10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Jun 08, 2005 at 03:24 AM

Hi Ashouja,

I think you only need to create a formula that has summation levels you desired.

Have you explored the formula creation option box? There are a lot of options there to summarize your data output.

Regards,

Jkyle

10|10000 characters needed characters exceeded
• Former Member
Posted on Jun 08, 2005 at 02:29 PM

Thanks for the response.

Yes, I can use SUMCT or other mathematical functions.

How do I build logic to sum only for the conditions described in the example. What would happen during drill-down or hierarchical display. .. Thanks