1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| WITH
MEMBER [Measures].[N] AS (
SUM(
[Measures].[Sale amount EXVAT]
)
)
MEMBER [Measures].[N-1] AS (
SUM(
PARALLELPERIOD( [Invoice date].[Calendar].[Calendar year], 1, [Invoice date].[Calendar].currentmember)
,[Measures].[N]
)
)
MEMBER [Measures].[DELTA] AS (
SUM([Measures].[N])
-
SUM([Measures].[N-1])
)
SELECT
NON EMPTY {
[Measures].[N],
[Measures].[N-1],
[Measures].[DELTA]
} ON COLUMNS,
NON EMPTY { (
[Invoice date].[Year].[Year].ALLMEMBERS
) } ON ROWS
FROM [SALE]) |
Partager