Skip to Content
author's profile photo
Former Member

Aggregation

Hello,

I need to do the following thing on query level

Calculate on material level like

(Key figure1/key figure2) * key figure 3

and show on material group level the sum of materials , no the (sum Key figure1/sum key figure2) * sum key figure 3

I MUST DO IT ON BEX LEVEL NOT ON CUBE LEVEL

THANKS

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Oct 06, 2005 at 12:33 PM

    For your calculated keyfigure, with the right mouse-key, select the properties. At the bottom there is an option about the calculation direction. With this option you may be able to do the trick.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 06, 2005 at 01:02 PM

    amount1 quantity1 quantity2 zzz

    Material 1 100 10 20 = 100*20/10

    Material 2 40 8 25 = 40*25/8

    Tot Mat gr

    the system calculate total fot Mat gr like

    (sum amount1/sum quantity1)*sum quantity2

    I want to calculate (before agrregation) like

    10020/10 + 4025/8

    Add comment
    10|10000 characters needed characters exceeded