Add grand total of stack bar report in SSRS

Bala Narasimha Challa 466 Reputation points
2020-12-04T04:14:59.763+00:00

Hi Team,
How to add grand total in chart reports. I need grand total as highlighted in out put screenshot

Input Chart:
45092-image.png

Out put :
44957-image.png

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,940 questions
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,596 Reputation points
    2020-12-04T06:53:47.517+00:00

    Hi @Bala Narasimha Challa ,
    According to your needs, I tested the display total above the stacked chart.

    In order to facilitate your better understanding, you could test by viewing the following articles and videos:
    Article:Display Total on top of Stacked Chart
    Video: How to Display Total on top of Stacked Chart in SSRS Report
    Hope this helps.
    Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,596 Reputation points
    2020-12-07T01:40:51.097+00:00

    Hi @Bala Narasimha Challa ,
    Has your issue been resolved?
    If you have any question, please feel free to let me know.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.