Get Percentage of total in ssrs

Christopher Jack 1,616 Reputation points
2022-03-25T11:28:47.613+00:00

Hi,

I am trying to get a percentage of a number from the total outside of the group in SSRS.

How do I reference the total outside?

See screenshot.

186981-image.png

TIA

Chris

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,853 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,571 Reputation points
    2022-03-28T01:54:59.037+00:00

    Hi @Christopher Jack ,

    How do I reference the total outside?

    What do you mean by Total here?
    If you are referring to the value of count(OrderNumber) or the value of Sum(OrderNumber), please refer to the following expression:

    =Fields!OrderNumber.Value/count(Fields!OrderNumber.Value,"ChalgroveCamaignCodes")  
    

    or

    =Fields!OrderNumber.Value/Sum(Fields!OrderNumber.Value,"ChalgroveCamaignCodes")  
    

    If not, please feel free to correct me and attach test data to reproduce your issue.
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful