Extra row under subtotal
Hi All,
Am using SSRS 2005, Is it posible to have another field(s) Subtotal Target, Variance under the SUBTOTAL (this subtotal field is the inbuilt subtotal function) row where you can put a
conditional expresion that will pick the value of the subtotal and substruct it from the
Subtotal Target and display the value in the Variance field for all the individual column. Please see below
StoreName
Quantity
A 10 20 30
B 100 200 40
subtotal 110 220 70
Subtotal Target 500 500 500 (How can this be included in the report)
(Variance)
390 280 390(How can this be included in the report)
Will be glad if any one could help
CRM Manager
March 23rd, 2011 4:08pm