Result line as aggregated values

[Former Member]

Dear BW Experts

Assuming the following situation of data:

C1: Characteristic-1

C2: Characteristic-2

KF: Keyfigures from selection or calculation

<u>C1........C2........KF</u>

c1........c21........1.000

...........c22........2.000

...........Result....<b>1.500</b>

Let's also assume that the result line is calculated e.g. as average of KF-values <> 0.

Is it possible also to get the following representation of the data ?

<u>C1........KF</u>

c1........<b>1.500</b>

[former_member188325]

Hi,

Ofcourse it is possible...

drag and drop C1 and C2 into Rows of Query designer and KF into columns.

c1 would be in first position and c2 would be in second position.

Go to properties of C2(from context menu)>set display-->'No display'.

thats it!

you can cross check Result by displaying C2.

Dont forget to reward if it helps!

[Former Member]

Hi - thank you very much for your reply

Doing so I get the following results:

C1........C2........KF

c1................1.000

...................2.000

...................1.500

But that is not what I want - there should be just one line

thany you for your advice

[Former Member]

Sorry - to be exactly - that was the result:

C1..................KF

c1................1.000

...................2.000

...................1.500

[former_member188325]

Hi,

You will not get C2 in report.please check it out again!

And set Suppress result rows of c2 to 'always'!

Hope this helps!

Message was edited by: Murali

[Former Member]

Hi Stefan,

try with "Constant Selection" in the properties of the Key Figure.

Ciao.

Riccardo

[former_member188325]

Hi,

Create a structure in rows->context menu->new selection->drag and drop C1 to right window.leave description window blank>ok.

you can include C2 in structure and hide it.

Then you will get only one line for C1.

thats what u r looking for?