on 2024 Feb 14 9:47 AM
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.
even if a sub articale is added (MCVT) to the query the sales value total shouldn't change
how can i achieve this with a calculated key figure on a composite provider?
thank you for your helo
Request clarification before answering.
User | Count |
---|---|
5 | |
4 | |
4 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.