Set Analysis - Percentage share of rows to one row

[janturon]

Hi,

I need to help with one expression. I have table with accounts in rows and prices. I need expression for pecentage share all rows with only one row (account 604). Table in excel looks like this:

%from604 = price / price(account(604))

account	price	%from604
501	1 225,00 €	84,48%
502	1 331,00 €	91,79%
503	1 001,00 €	69,03%
504	502,00 €	34,62%
604	1 450,00 €	100,00%
605	2 136,00 €	147,31%
607	1 200,00 €	82,76%

[tresesco]

Sum(price)/Sum(Total {<account={'604'}>} price)

Then in the presentation tab, enable 'Show in Percent(%)'

[janturon]

Doesnt work, If you have more columns like thist:

	p01	p01	p02	p02
acoount	price	%from604	price	%from604
501	1 225,00 €	84,48%	1 285,00 €	64,22%
502	1 331,00 €	91,79%	1 325,00 €	66,22%
503	1 001,00 €	69,03%	1 152,00 €	57,57%
504	502,00 €	34,62%	800,00 €	39,98%
604	1 450,00 €	100,00%	2 001,00 €	100,00%
605	2 136,00 €	147,31%	6 045,00 €	302,10%
607	1 200,00 €	82,76%	1 100,00 €	54,97%

[sunny_talwar · Accepted solution]

Seems like you have a second dimension (let's call it PriceType)... in that case modify your expression to this

Sum(price)/Sum(Total <PriceType> {<account={'604'}>} price)

[janturon]

thank you very much. it works 🙂