cancel
Showing results for 
Search instead for 
Did you mean: 

Bex Query - 1 result value for structure element

ManuelaW
Explorer
0 Kudos

Hello Sap community,

I need some support from your side. Following situation.

In my rows I have a structure with three selections and a result formula( result = Selection 1 + selection 2 + Selection 3)

When I select now via free characteristics a additional column following table is present:

Structure    character     KYF Count Head

Selection 1     A        22

Selection 2    B        33

Selection 3    C        10

Result         A        22

Result         B        33

Result         C        10

My issue now is, that I receive three lines of Result values (because of the selections in the structure) but I only need one result, in which all selection values of the characteristics are summed up.

Someone of you has a guess or trick how to enforce this one result line?

Thanks for your support.

Regards,

Manuela

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member200967
Active Participant
0 Kudos

hallo Manuela,

Have you tried suppressing the result rows of the Free characteristic that you are drilling down? I have a similar report and I get the below result in my report.

StructureFree CharKeyFigure
CustomerV120
V210
Result30
StoreV15
V26
Result11

I am getting the Result here beacuse i have not suppressed the result row of the Free char that I am drilling down.

You can try suppressing the result rows for Free characteristics and see if it resolves your issue.

ManuelaW
Explorer
0 Kudos

Hi Manpreet,

thanks for your feedback, unfurtunatelly it's not the solution I like to have - with the function "always suppres". I don't like to see the result lines of the free characteristics, I would like to see the overall result.

Once again the description of my target query:

Structurefree charkeyfield
Customer 1 A10
B10
C10
Customer 2A10
C10
E10
Overall Result60

Hopefully the community has some other guesses how to solve my issue.

Thanks for supporting me. 🙂

Regards,

Manuela