dbTalk Databases Forums  

How to aggregate with different function in different level

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap How to aggregate with different function in different level

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss How to aggregate with different function in different level in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ad
 
Posts: n/a

Default How to aggregate with different function in different level - 10-08-2004 , 10:19 AM





I have an area dimension with three levels: Area, County, and School
I want to aggregate the number of students with different function in
different level, like that in the school level, I want to aggregate student
number with max, in the County and Area level, and I want to aggregate the
student number with sum.
How can I do that?


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top