I want to restrict data within a query line by customers of a specific industy code.
However, the industry code is a navigation attribute only.
SAP does not allow me to restrict the values.
Goal I want to accomplish:
customer industry code sales
4711 A 100
4712 A 200
4713 B 300
line 1 total sales 600
line 2 total sales code A 300
line 3 percentage A to total 50% (= 300/600) as a formula (line 1/line 2).
Line 2 is the problem.
Any tips to get around are welcome.
Thanks a lot in advance