Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Business Intelligence » Report
Add to briefcase

Report Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
khasim76
Posted Friday, May 15, 2009 2:10 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, January 21, 2012 2:04 PM
Points: 27, Visits: 31
Assume you have a report table (no Breaks) with the following Dimensions: State, County, and City with the measure, Population. Write a formula which caclulates the weighted average population of city divided by state.

Please give me a solution to this question
Post #718278
Brandie Tarvin
Posted Monday, May 18, 2009 4:35 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:39 PM
Points: 6,668, Visits: 5,695
This sounds suspiciously like a homework or test question. We don't answer those on this site. It shouldn't be too hard for you to find the answer. Look up MDX in Books Online.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #718919
Tim Mitchell
Posted Wednesday, May 20, 2009 9:30 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 4:11 PM
Points: 1,033, Visits: 2,593
Must be finals week


Tim Mitchell
SQL Server MVP
www.TimMitchell.net
twitter.com/Tim_Mitchell
Post #721084
Bruce W Cassidy
Posted Wednesday, May 20, 2009 9:34 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, March 22, 2013 11:49 AM
Points: 945, Visits: 998
Are we talking a SQL Server T-SQL formula, or a SQL Server Analysis Services MDX formula, or a SQL Server Reporting Services inline formula or a VB.Net formula or an Excel formula or a Crystal Reports formula or...

Also, what have you already tried? What is your definition for the value you want?
Post #721087
Brandie Tarvin
Posted Thursday, May 21, 2009 5:02 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:39 PM
Points: 6,668, Visits: 5,695
Tim Mitchell (5/20/2009)
Must be finals week


I didn't even think about that. You're probably right. @=)

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #721227
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.