Hello Experts,
I'm using Reporting Services ver 2005. I'm trying to accomplish the following: I have two group in my report group A and group B
Total Amt
group A 100
group A -50
group A -30
group A 150
group B = -80
I need to sum the Total Amt for group B only when the Total Amt in group A is negative. so my total for group B = -80. I have try nest aggregate but seems like RS does not allow me to do this. You input/suggesstion is greatly appreciated.
Thanks