Skip to Content
avatar image
Former Member

How to display Yearwise total on right side in cross tab report ?

Dear Experts ,

I had created a manual total calculation in a cross tab report with the help of below post.

I want to display YTD on the right side at the end of the month (next to Dec).

Please suggest how to display it in right.

ytd.jpg (412.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 20, 2017 at 09:35 PM

    1. Right-click the Cross-tab,

    2. Select Cross-tab Expert

    3. Go to Customize Style tab

    4. Uncheck Row Tortals on Left

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vitaly ,

      Thanks for your reply, When we uncheck Row totals on left, column value is getting mismatch, Because the total column is manually calculated using calculated members option in cross tab.

      for ex YTD JAN FEB MAR APR

      10 1 2 3 4

      After Uncheck Row Totals on Left, I am getting below output without changing row value .


      10 1 2 3 4