when I have different characteristics like for example:
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!
I did it like this:
created one restricted key figure for this ONE key figure (constant selection "=") with properties "calculation result as last value".
Then one new formula with this restricted key figure and with exception aggregation "last value" and characteristic "0calmonth".
Now it shows me the result correct for each characteristic. If I remove one characteristic I think the calculation is also correct.
I have only a few data sets currently but I will test it in detail.
But for the last characteristic 0C_CTR_AREA when this is the first column in query it does a summation of the last value of 0Comp_Code.
I think this is normal behavior because which one of the - for example two credit control areas like 1000 and 2000 - should be selected as "last value" for result.
There are two values which are correct 1000 with 1 Euro and 2000 with 2 Euros.
But as a result the summation is wrong.
Maybe it is possible to deal with two characteristics. One Standard 0C_CTR_AREA and one new created 0C_CTR_AREA_2 and then there could be presented the last value for each?
I think there's a workaround for this.
For the three characteristics you want to show the last value of, create a replacement key figure that you can use in a formula. This way, you have the key values of those characteristics in a key figure so you can create a condition only to show the last value. Hide the three colums when you're done.
To make sure the other key figures show the result of all different values of that characteristic in one line, you can use a constant selection on those key figures.
Let me know if it works or of you need any more details about this solution.
I'm sorry, I meant a key figure with a formula variable based on a replacement path. To use this, you first create a formula and within that formula you create a formulavariable. Choose type replacement path and select for example the key of 0CUSTOMER to be the replacement value.
You now have a column with the customer number in it, like e key figure value. This way you can use a condition to only display the highest value for each 0C_CTR_AREA and 0COMP_CODE combination.
Does this help you?