Skip to Content
0
May 19, 2016 at 06:17 PM

Navigation attribute for selection

457 Views

Hello,

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:

Data:

customer industry code sales

4711 A 100

4712 A 200

4713 B 300

Query:

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

Thomas