10 Replies Latest reply: Sep 1, 2011 6:47 PM by Zo Lo RSS

Different values in results for characteristics with query designer

Zo Lo
Currently Being Moderated

Hi Gurus,

 

when I have different characteristics like for example:

 

1) 0C_CTR_AREA

2) 0COMP_CODE

3) 0CUSTOMER

4) 0RISC

5) 0INDEX

 

for number 3, 4 and 5 I want as a result the last value (key figure setting in query designer "last value" > works).

 

But for 1 and 2 I want the summation for this key figure.

 

When the key figure was adjusted with "last value" in query designer, is it possible to assign in some way the summation to number 1 and 2?

 

Right now it shows for 1 and 2 also the "last value" as result.

 

Thanks in advance!

Actions