On searching forum I found how to express %ages of groups If you want to get the percentage of Group 2 over Group 1, please try the expression below. Code Snippet =Sum(Fields!Ponits.Value)/Sum(Fields! Ponits.Value,"group1") How do you do this for Report total I tried =Sum(Fields!Ponits.Value)/Sum(Fields! Ponits.Value,"Report"), but this failed. As a work around I have defined a group which encompasses all data. This seems a bit long winded is there an easier way? Ian

Try this, Name the Report Total cell and reference that in your formula. To refer the Report total, here is sample expression =ReportItems!<Name you gave>.Value To give a name to Report Total, just click on the cell and go to properties pane and change the "Name" to a meaningful name. regards Natraj regards Natraj www.BItipsntricks.com

HI, =Sum(Fields!Ponits.Value)/Sum(Fields! Ponits.Value,"TablixName") Change the name with your table / matrix name. Hope this helps. Regards, Asim Bagwan Kindly mark the replies as Answers if they help!

Thanks that works perfectly Ian

Try this, Name the Report Total cell and reference that in your formula. To refer the Report total, here is sample expression =ReportItems!<Name you gave>.Value To give a name to Report Total, just click on the cell and go to properties pane and change the "Name" to a meaningful name. regards Natraj regards Natraj www.BItipsntricks.com