How can i work out % of a group within a group?

[#1]

Can anyone help??

I have data in a table:

	Total	A			B
		Total	x	y	Total	x	y
Total	29	12	2	10	17	10	7
Group 1	17	9	2	7	8	5	3
Group 2	12	3	-	3	9	5	4

I can create a table showing the % of groups A & B as:

	Total	A			B
		Total	x	y	Total	x	y
Total		100%	17%	83%	100%	59%	41%
Group 1		75%	17%	58%	47%	29%	18%
Group 2		25%	-	25%	53%	29%	24%

Using an expression

count( "variable")/count(total <"Name for A & B variable"> "variable")

I want to work out the %, so I get a table like this, showing the % within each column:

	Total	A			B
		Total	x	y	Total	x	y
Total		100%	100%	100%	100%	100%	100%
Group 1		75%	100%	70%	47%	50%	43%
Group 2		25%	0%	30%	53%	50%	57%

[#2 · Accepted solution]

try to modify your expression to be like:

count( "variable")/count(total <"Name for A & B variable", "Name for x & y variable"> "variable")