pie chart % of dimension total

[#1]

Hi  i would like to use the total of column(1) and work out the percentage of the next column.

i have tried using the following

count(OptionNo) / count(Total (OptionNo) without success.

the example below i provide is from excel using the row cell ie. Marint alpint 200 /2144 = 9,3 %.

any help greatly appreciated

see desired result below

Theme	OptionCount	%
	2144	100,0%
Marint Alpint	200	9,3%
Skandinavisk	422	19,7%
Tradition	973	45,4%
Undefined	118	5,5%
-	431	20,1%

[Gysbert_Wassenaar · Accepted solution]

Try copying your first expression and enabling the Relative option.

[alexandros17]

This is my example built on your data ... let me know