percentage calculation (do i have to use set analysis?)

[#1]

Hi everybody.

I have to make a percentage calculation above the total. For example i have a lot of Quantitys

Quantitys

100

250

300

500

100

And i have to make the % of this quantitys above the total ( 100/1250) (250/1250 etc..)

What formula should i use? I guess it may be set analysis

Thank you all

Greetings.

[#2]

Ok thank you.

But now i realized that i dont have to put sum(price). Only price

and now i have to do something like this

precio* sum(CantidadAdjudicada)  / TOTAL (precio * sum(TOTAL CantidadAdjudicada))

And it isn´t working haha

What i have to do ??

Thank you! cheers!

[#3]

Something similar to this ?

precio* sum(CantidadAdjudicada)  /

precio * sum(TOTAL CantidadAdjudicada)

or

sum(precio * CantidadAdjudicada) /

TOTAL (sum(precio * CantidadAdjudicada))

[stigchel]

The syntax of your first suggestion is correct, depending on your dimension you need to place precio inside the sum function (question is, is there more than one price for each dimension value). The TOTAL qualifier always needs to be inside the aggregation function, in this case Sum.