2 Replies Latest reply: Jun 21, 2011 8:26 AM by user137887 RSS

    Grand total of the coloumns for a report

    user13001889
      I need to get the below rek

      I have a dashboard prompts

      companyID company name calender date(between date 1 and date 2) source transactions results

      I have these coloumns in the report

      searchdate companyId company name source transactions results
      1/1/2011 "1" dell " site " " 1 " " 2"
      1/1/2011 2 cannon site 2 3
      1/10/2011 5 acer site 4 5
      2/14/2011 9 hitachi site 3 4
      2/15/2011 4 hp site 4 2
      ..
      ..
      ...


      so i need to get this:I want grand total of all the trasactions and results to be shown and i need to show the months like below

      searchdate companyId company name source transactions results
      Jan 1 dell site 1 2
      2 cannon site 2 3
      5 hitachi site 4 5

      Grand total 7 10

      FEB 9 hitachi site 3 4
      4 hp site 4 2
      Grand total 7 6
      ..
      ...
      ...

      so in the dsahboard prompt what ever date i select it should not show the all the trasactions date but instead of date i need to show months and grand total of "Trasaction" and "results"

      Any help is appreciated.

      Thanks.

      Edited by: user13001889 on Jun 19, 2011 1:23 PM