This discussion is archived
2 Replies Latest reply: Jun 21, 2011 6:26 AM by user137887 RSS

Grand total of the coloumns for a report

user13001889 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points