Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH member AverageSpend AS
- [Measures].[Amount] / [Measures].[TRANSACTION COUNT]
- SELECT
- AverageSpend ON COLUMNS,
- {
- [Customer].[Sex].[Female],
- [Customer].[Sex].[Male]
- } ON ROWS
- FROM [Sales]
- WHERE ([Shop].[Apple])
Add Comment
Please, Sign In to add comment