cancel
Showing results for 
Search instead for 
Did you mean: 

sum over rows and columns

Private_Member_24235
Participant
0 Kudos

Dear all,

we have created a query with three restricted key figures in rows and one single characteristic in the column. The result row for the characteristic is displayed (for each row), but we want also have a result row for the restricted key figures in each column.

So far we have tried to set "calculate results as sum" for all restricted key figures, but this was not working.

Is there any way to display a summ for the columns?

The query was created in BW 3.5 Any help would be great.

Best regards,

Stefan from Munich/Germany

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

HI,

the result will be caluculated generally across the Key figure direction and Overall result will be seen

If you want to change the Caluculation direction, i.e,Across Rows/Across columns

In query Designer -> Properties of CKF/RKF -> Caluculations Tab ->Select the option caluculate along the rows/Coloumns as per your requirement.You may need to change the same seeting for all three RKFs

It may work out fr you:)

Sriman

Former Member
0 Kudos

Hi Stefan,

The option "Calculate Results as..." as "Summation" for each and every Restricted KF selected in Rows will work fine. Check the same for all the three KF's.

The output when you execute may get scroll option if there are more number of records. Scroll to the last column to see the results. If you want to have results for each column single values too... u can have the option of "Calculate single values as..." as "Summation".

The results for each column will surely be displayed when u check this option.

Assign points if this helps u...

regards,

KK.