Skip to Content
0
Former Member
Feb 22, 2011 at 02:37 PM

How to use percentage functions in BEx with structures

123 Views

Hi, I need a help.

I have a query with a structure in the rows: two characteristics at left then the structure.

Plant, Year/Month and a structure with 3 lines (Line A = movement type = 1, 2, 3, Line B types 4, 5, 6, Line C types 7, 8, 9).

In the rows just a quantity.

I'm trying to use percentage functions CT or GT in the rows, but it's not working.

The idea is something like:

Plant 01 07/2010 Line A 30 30%

Line B 20 20%

Line C 50 50%

Result 33%

08/2010 Line A 40 20%

Line B 60 30%

Line C 100 50%

Result 66%.

When I do not use the structure percentage function works well, but with the structure results are completely wrong.

Any help will be appreciated.

César Menezes