Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Try sum ({<ProductType = {'Ace'},MatchNo = {'*ZZ'} >} TOTAL <Line,Date,Type> Qty)
Try sum ({<ProductType = {'Ace'},MatchNo = {'*ZZ'} >} TOTAL <Line,Date,Type> Qty)
Thanks! it added one more row and I was able to hide that using Suppress Null check box from dimension
Try this
sum ({<ProductType = {'Ace'},MatchNo = {'*ZZ'},ProductType = >} Qty)
hope this helps