Ignoring dimension for calculating sum

[#1]

I have the following chart in QV. Line , Date , Type and Product are the dimensions while Qty and Type Total are the expressions.

In the chart Qty is being calculated correctly using the formula : sum ({<ProductType = {'Ace'},MatchNo = {'*ZZ'} >} Qty)

But I am not able to get the Type Total correctly. I want the Type total to be calculated ignoring the product column. Like in the following chart for X1 , 04/08/2013 and Type C - Type Total should be 45 in both the rows.

Line	Date	Type	Product	Qty	Type Total
X1	4/8/2013	A	P1	20	20
		Total			20
		B	P1	30	30
		Total			30
		C	P1	15	45
			P2	30	45

[Gysbert_Wassenaar · Accepted solution]

Try sum ({<ProductType = {'Ace'},MatchNo = {'*ZZ'} >} TOTAL <Line,Date,Type> Qty)

[#3]

Thanks! it added one more row and I was able to hide that using Suppress Null check box from dimension

[SunilChauhan]

Try this

sum ({<ProductType = {'Ace'},MatchNo = {'*ZZ'},ProductType = >} Qty)

hope this helps