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
PLEASE DONT OFFER THE "BEFORE AGGREGATION". AT FIRST , I DONT SEE IN IN BW 3.1. SECOND , THIS BULLSHETIMG FUNCTIONALITY NEVER WORKED!