Calculation Help in query - how to get desired results?

[Former Member]

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)

[Former Member · Accepted solution]

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

[Former Member]

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