Problems with cumulation.

[MichaelFL]

Hello everyone, in the attached table I cumulate the sales per material class in column kum.

So far, so good. It works. But when i add another dimension, the cumulation does not work any more.

I use the following formulas for the key figures:

dmbtr: sum(      {$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1])

total mat class:   Sum(TOTAL <MARA.MATKL_Description> {$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1])

in %: Sum({$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1]) / Sum(TOTAL <MARA.MATKL_Description> {$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1])

kum:RangeSum( Above(  Sum({$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1])  /

Sum(TOTAL <MARA.MATKL_Description> {$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1]        ),

        0, RowNo()  ) )

I need help please 🙂

[Chanty4u]

Try this 

kum:

RangeSum(

  Above(

    Sum({$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1]) /

    Sum(TOTAL <MARA.MATKL_Description> {$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1]),

    0,

    RowNo(TOTAL <MARA.MATKL_Description>)

  )

)

[MichaelFL]

does not work. Error in expression. 

[marcus_sommer]

An accumulation against multiple dimensions isn't trivial and may need TOTAL for the above() and some aggr() functions. Take a look on the last comments to this blog-posting:

Recipe for a Pareto Analysis – Revisited - Page 9 - Qlik Community - 1473684

to get various hints what you could do.

[MichaelFL]

not really helpful due to the fact that I want a pareto for each material group. 

[marcus_sommer]

I wouldn't say that - only because SDT didn't realized a quick implementation. The essential aspect is the comprehending of the aggr() function which creates a virtual table against the virtual table behind the object and because of the fact that there might be several aggr() combined and/or nested it's really a complex measurement. Like hinted in the other posting it's important to comprehend what's happening by the seemingly not working attempts.