Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
way to get "Sales Comparison" ...
Let's go another way, Say, we got Dim Year, Dim Store and Measure Sales, need to compare A store this Year's Sales with B Store last year's Sales. How to the comparison result? MDX? thanks a lot!- johnwps
- Post #2
- Forum: Microsoft SQL Server: Reporting Services
-
way to get "Sales Comparison" ...
Say, need to compare A Store’s this year sales with B store’s last year sales, Now, we have four dimensions 1.Dim Year –Fiscal Year List 2.Dim Year_Compare - Fiscal Year List(copy of Dim Year) 3.Dim Store – Stores Name List 4.Dim StoreCompare - Stores Name List (copy of Dim Store) Two...- johnwps
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Reporting Services
