Hello,
I have a matrix report with
a Column called SaleType and rows containing salesreps
Table looks like
business home business2 home2
John 50 12 0 120
Mary 100 11 50 23
Peter 20 10 20 11
I am trying to create another column called Total Business Sales which is a total off Business + business2
Because it is a matrix report the there is only one column in design mode which represents the business or home types. Not sure how to add the 2 business types together
Im trying an expression =IIf(Fields!SaleType.Value='business' OR 'business2' ,SUM(Fields!Sale.Value),0)
This only gives me the Sum off ALL the Saletype Value and doesnt determine add up only the values which fall under business or business2...if somehow I can put a condition on the SUM
Can someone please help
thanks
