Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- With
- Member [Time].[Period] as
- Aggregate( ${dateFromParameter} : ${dateToParameter} )
- Member [Measures].[Unit Price] as [Measures].[Sales] / [Measures].[Quantity]
- Member [Measures].[Contact Name] as
- [Customers].CurrentMember.Properties("Contact First Name") || " " ||
- [Customers].CurrentMember.Properties("Contact Last Name")
- Set CUSTOMERS as Filter( [Customers].[Customer].Members, [Measures].[Sales]>0 )
- Select
- CUSTOMERS on ROWS,
- { [Measures].[Contact Name],
- [Measures].[Sales],
- [Measures].[Quantity],
- [Measures].[Unit Price]
- } on COLUMNS
- From [SteelWheelsSales]
- Where
- ( [Markets].[${territoryParameter}].[${countryParameter}],
- [Product].[${productParameter}],
- [Time].[Period] )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement