Skip to Content

How to add summery column in Cross Tab report

Hi Experts,

Currently I have report of following format,


April—2016 May—2016 June—2016 July—2016 Aug—2016 Sum-2016 Item1 1 1 2 2 4 10 Item2 10 7 17 Item3 20 30 2 5 57 Total 31 31 9 4 9 84

I want following format


April—2016 May—2016 June—2016 July—2016 Aug—2016 Sum-2016 Sum-2015(From April to Aug 2015) Item1 1 1 2 2 4 10 9 Item2 10 7 17 15 Item3 20 30 2 5 57 40 Total 31 31 9 4 9 84 64

SO can anyone tell me how to add this previous year summery field in current report.?

Thanks in advance.

Regards,

Mahesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 07, 2016 at 01:50 PM

    Hi Mahesh,

    If you need that column in a crosstab, you'd need to use 'Calculated Members' > calculate the summary value for each item outside the crosstab > Use some complex array logic to print the value for each item in the crosstab.

    Or, you could use a SQL Query that returns just the summarized columns you need per item.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Abhilash,

      I tried your solutions but it is not working. Now i did is that i added new column in procedure as YOY for records of Year 2015 & then i put that in summery field of cross tab report. i suppressed month-2015 data from other column. I am able to get additional column now but only issue is that i am not able to get its total as shown below in RED color.


      April—2016 May—2016 June—2016 July—2016 Aug—2016 Sum-2016 Sum-2015(From April to Aug 2015) Item1 1 1 2 2 4 10 9 Item2 10
      7

      17 15 Item3 20 30
      2 5 57 40 Total 31 31 9 4 9 84 64

      Can you help in that?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.