Re: subtotal on a matrix
From: Adam Machanic (amachanic_at_hotmail._removetoemail_.com)
Date: 01/25/05
- Next message: umashankar: "Inner join limitations."
- Previous message: Dietmar Flick via SQLMonster.com: "Re: Moving SQL DB to new server with different DB name"
- In reply to: offa via SQLMonster.com: "subtotal on a matrix"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 Jan 2005 09:32:33 -0500
Look up the topic ROLLUP Operator in BOL.
-- Adam Machanic SQL Server MVP http://www.sqljunkies.com/weblog/amachanic -- "offa via SQLMonster.com" <forum@SQLMonster.com> wrote in message news:264b1fd49f4c4188ab218c39cb3479fc@SQLMonster.com... > i have this matrix report that looks like that : > > Type1 Type2 > Count Time Count Time > Zone1 2 20.5 3 20 > Zone2 23 40 25 35 > Zone3 11 40.5 23 13.3 > > i would like to sutotal the columns "Count" and "Time" for each type, but i cant seem to get the grouping right so i could subtotal the of each column. is there a way to do this? > thanx in advance > > -- > Message posted via http://www.sqlmonster.com
- Next message: umashankar: "Inner join limitations."
- Previous message: Dietmar Flick via SQLMonster.com: "Re: Moving SQL DB to new server with different DB name"
- In reply to: offa via SQLMonster.com: "subtotal on a matrix"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
