I need help on mdx avg funtion

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

I need help on mdx avg funtion

Author

Topic

zhanglise08
Starting Member

1 Post

Posted - 2011-07-28 : 03:26:11

I have 1 table

Col1 Col2 Avg

4 5

3 7

4 6

5 7

Grand Total 1 6.25
4 5

3 8

4 6

5 8
Grand Total 2 6.75
Grand Total 3 6.50

I need a formula [Sum(Col1xCol2)] /[ Sum (Col2) ]

Example [(4x5)+(3x7)+(4x6)+(5x7)]/(4+3+4+5)=6.25
and Grand Total 3=(Grand Total 1+Grand Total 2)/2=(6.75+6.25)/2

I need help on mdx avg funtion

Thanks a lot

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-07-29 : 02:39:02

are col1,col2 coming from same dimension?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources