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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics