Goal:
Display the chart without displaying "Bikes", "Bikes - Internet Sales Amount" and "Bikes - Internet Tax Amount". Please review at pictures.
However, "Bikes", "Bikes - Internet Sales Amount" and "Bikes - Internet Tax Amount" shall be available in the list but not in the chart.
Problem:
I do not know how to remove "Bikes", "Bikes - Internet Sales Amount" and "Bikes - Internet Tax Amount" in the chart.
Information:
*I'm using SQL server 2012
*The data source is SSAS from AdvenctureWorks.
SELECT NON EMPTY
{
[Measures].[Internet Standard Product Cost],
[Measures].[Internet Sales Amount],
[Measures].[Internet Total Product Cost],
[Measures].[Internet Tax Amount]
} ON COLUMNS,
NON EMPTY
{
([Customer].[Customer Geography].[Customer].ALLMEMBERS * [Product].[Product Categories].[Product].ALLMEMBERS )
} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM
[Adventure Works] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS