Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
SSRS Report RRS feed

 > 

  • Question

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

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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