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.
| Author |
Topic |
|
shanmugaraj
Posting Yak Master
219 Posts |
 Posted - 2011-03-08 : 07:16:59
|
| Hi,I want to get the data based on month which is passed as parmeter .If i select june, i should display the data for months and before june. ie : from Jan to June.kindly help me on the MDX Query.MDX QUERYSELECT {[Measures].[Internet Sales Amount]} ON COLUMNS, [Date].[Month of Year].[Month of Year] ON ROWS FROM [Adventure Works] WHERE [Geography].[City].&[Abingdon]&[ENG]RESULT Internet Sales AmountJanuary $2,375,856.68February $2,502,386.86March $2,610,615.17April $2,778,842.08May $3,114,646.27June $3,180,923.99July $1,911,262.79August $1,899,606.67September $1,834,668.15October $2,009,169.29November $2,076,069.60December $3,064,629.66THANKSSHANMUGARAJnshanmugaraj@gmail.com |
|
|
|
|
|
|
|
Top Filter of Data based on Parameter