Totals over a Column

[#1]

Dear helper,

How can i get the subtotals from a Column (with multiple dimensions), to use in an another object?

Example column "Column 1":

A sum on all these results, to use on this radar chart:

A solution would be to save those column sum (on "Column 1") in a variable, i guess. I don't know how to do that though.

Any ideas? Thank you in advance!

Kind regards,

Roel Beun

[#2]

If you want to use a variable, you can use set analysis to create the value you need.

=Sum({$<Dim1={...},Dim2={...}>} Column1)

Create a set by using the dimensions necessary to select all the values in Column1 you want to sumarize.

[#3]

Hi,

Hope this helps

-Ravi Kumar

[#4]

Thank you all for your replies.

Oke, iam getting somewhere now. When i use static data, my formula is working. Now i have in my load script the following:

SET

MaximaalAantalPunten = 4;

SET

TotaalAantalKenmerken = Count(kenmerk) * $(MaximaalAantalPunten);

In most cases TotaalAantalKenmerken holds the number 16.

When i put the 16 as a number in my previous mentioned formula i get as answer: 25

Formula:

=(

Sum({$<dimensie={"Kennis/Product"}>} [Kenmerk waarde]) / 16 ) * 100

When i put in the variabel TotaalAantalKenmerken iam getting strange numbers. It says it holds the number 772 instead of 16

Formula:

=(Sum({$<dimensie={"Kennis/Product"}>} [Kenmerk waarde]) / TotaalAantalKenmerken ) * 100

OR

=(Sum({$<dimensie={"Kennis/Product"}>} [Kenmerk waarde]) / $(TotaalAantalKenmerken) ) * 100

How can i get the variabel TotaalAantalKenmerken in my formula with the correct number, 16?

[#5]

Thank you all for your response. The problem i mentioned in this thread has been solved with above suggestions.