June 6, 2010 at 11:41 pm
Hi all
I am kind of stuck with the report that I have worked on.
I have a table in SQL that basically shows funding received by each source and the total received by category
e.g.
Funding Source Category Total Received
A <$1000 10,000
A $1000 - $4000 12,000
A $5000 + 2000
B <$1000 15,000
B $1000 - $4000 20,000
b $5000 + 30,000
the report at present shows information as above. however I would like it to show the data so that A appears ones at the Top and the others as detail.
So
Funding Source
A B
Category Total Received Category, Total Received
<$1000 10,000 <$1000 15,000
$1000 - $4000 12,000 $1000 - $4000 20,000
$5000 + 2000 $5000 + 30,000
Can someone please let me know if there is a way of doing this...
thanks in advance 🙂
Vani
June 7, 2010 at 10:58 pm
Never mind... I figured it out 🙂
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply