Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Swapping the charactersitcs in query


I've a query in the following format

Company Code Material Group Ker Figure1 KeyFigure 2

1000 AB 3000 40000

2000 AB 5000 60000

3000 AB 7000 90000

total 15000 190000

when you swap the Material Group to company code then the values for the key figures are coming in percentage. Can we avoid the percentage values?

after swanpping the result will be...

Material Group Company Code Ker Figure1 KeyFigure 2

AB 1000 20% 25%

AB 2000 30% 30%

AB 3000 50% 45%

total 15000 190000

Advance thank you very much. I would really appreciate for your responce.

Not what you were looking for? View more on this topic or Ask a question