cancel
Showing results for 
Search instead for 
Did you mean: 

calculated key figure, fixed aggregation by characteristic

ELKASAH
Newcomer
0 Kudos
162

Hello experts, 

i have from a sales ADSO (Advanced DataStore Object) in an SAP BW/4HANA environment. This dataset is structured to track sales related to individual articles. Each article is categorized under a 'Universe' (a group of articles), and each 'Universe' falls under a broader category called 'Segment'.

with a query, i need a key figure that aggregate the sales value ONLY on the Univers level. 

for the example below, it should calculate the sales value of spring and display it against the sales value of all articales without being influenced by the drill down in the query.

ELKASAH_0-1707903184703.png

even if a sub articale is added (MCVT) to the query the sales value total shouldn't change

ELKASAH_1-1707903904022.png

how can i achieve this with a calculated key figure on a composite provider?

 

thank you for your helo

 

Accepted Solutions (0)

Answers (0)