Skip to Content
author's profile photo Former Member
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)

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.