Percentage of a subset

beunderf — Thu, 07 Jul 2011 15:03:22 GMT

I have the following data:

I want to create the following Chart:

Line	Type	Product	Total	Average (per day)	Product segregation(per line)
1	A	Card	11	5,5	31%
1	A	Cash	6	3	17%
1	A	Other	18	9	51%
		TOTAL:	35		100%
2	A	Card	12	6	33%
2	A	Cash	10	5	28%
2	A	Other	14	7	39%
		TOTAL:	36		100%

My problem is that I dont know how create a expression for the 'Product segragation' part.

The 31% should be calculated the following way:

Sum(numbers of line 1, type A, product Card) / SUM (numbers of Line 1, type A)

In numbers:

11 / 35 = 31%

Can anyone help me?

Thanks in advance

Frank

Re: Percentage of a subset

nagaiank — Thu, 07 Jul 2011 15:31:53 GMT

Change the expression for the segregation to Sum(Number)/Sum(TOTAL<Line> Number)

The modfified qvw file is attached.

beunderf — Thu, 07 Jul 2011 15:35:40 GMT

Thanks for the quick response!