WITH
MEMBER [Measures].[Sales Value LM] AS
([Measures].[Sales Value], [Date Calculation].[Comparison].[Prior Month])
MEMBER [Measures].[Sales Value LM ALL] AS
([Measures].[Sales Value LM], [Product].[Product Hierarchy].[All])
MEMBER [Measures].[Sales Value ALL] AS
([Measures].[Sales Value], [Product].[Product Hierarchy].[All])
MEMBER [Measures].[Sales AGM Value LM] AS
([Measures].[Sales AGM Value], [Date Calculation].[Comparison].[Prior Month])
SELECT NON EMPTY
{ [Measures].[Sales Value]
, [Measures].[Sales AGM Value]
, [Measures].[Sales Value LM]
, [Measures].[Sales AGM Value LM]
} ON COLUMNS
, NON EMPTY
{ [Branch].[Business Hierarchy].[Business]
* [Date].[Date Hierarchy].[Month]
} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM ( SELECT STRTOMEMBER(@parmDate_Month).LAG(11): STRTOMEMBER(@parmDate_Month) ON COLUMNS
FROM ( SELECT STRTOSET(@parmBranch) ON COLUMNS
FROM [sample Cube]
)
)
FILTER TABLIX VALUES TO CURRENT MONTH SELECTION ONLY SINCE THE DATASET SHOWS 12 MONTH TREND
1. Click Tabix\ Row \ Column group properties
2. Select Filters
3. Add filter to include group values where the following conditions are true
Sample:
Expression: [Month.UniqueName]
Operator: =
Value: [@parmDate_Month]