SSRS Report RRS feed

  • Question

  • How to calculate percentage using subtotal inside Matrix in SSRS report?
    Saturday, June 17, 2017 10:32 AM

All replies

  • How do you want the percentage to be calculated? 

    Since its a matrix report that means you have a dynamic Column and Row so  first you need to arrive on which basis you want to achieve the  percentage and then apply the formulas accordingly. if you just want to have % field overall then you can just do something like = value/(CountRows("DataSetName") *100.

    So the answer would be depending on your requirement.

    If my response answered your question, please "mark the response as an answer" and also "vote as helpful". Regards, Hari. www.crm2011byhari.blogspot.com

    Monday, June 19, 2017 5:28 AM