Is it possible to create a Custom PivotTable filter list derived from values from a cube that it's hitting? I'm using Excel 2013.
Like to create Field Name (Filter) 'View_Type' with selections:
Quarter To Date
Previous Week
Filter values are:
Quarter To Date --> [DIM_WEEKLY_CALENDAR].[Fisc Week Value].[All]
Previous Week --> EXTRACT({[DIM_WEEKLY_CALENDAR].[Week Aging].&[0],[DIM_WEEKLY_CALENDAR].[Week Aging].&[1],[DIM_WEEKLY_CALENDAR].[Week Aging].&[14],[DIM_WEEKLY_CALENDAR].[Week Aging].&[53]}*[DIM_WEEKLY_CALENDAR].[Fisc Week Value].Children,[DIM_WEEKLY_CALENDAR].[Fisc Week Value])
Can this even be done and if so how?
This is from a SSRS report that users want exact same filtering etc in excel and I can't figure this out.. as some of my custom metrics are based on this custom 'View_Type'.
Thanks
Like to create Field Name (Filter) 'View_Type' with selections:
Quarter To Date
Previous Week
Filter values are:
Quarter To Date --> [DIM_WEEKLY_CALENDAR].[Fisc Week Value].[All]
Previous Week --> EXTRACT({[DIM_WEEKLY_CALENDAR].[Week Aging].&[0],[DIM_WEEKLY_CALENDAR].[Week Aging].&[1],[DIM_WEEKLY_CALENDAR].[Week Aging].&[14],[DIM_WEEKLY_CALENDAR].[Week Aging].&[53]}*[DIM_WEEKLY_CALENDAR].[Fisc Week Value].Children,[DIM_WEEKLY_CALENDAR].[Fisc Week Value])
Can this even be done and if so how?
This is from a SSRS report that users want exact same filtering etc in excel and I can't figure this out.. as some of my custom metrics are based on this custom 'View_Type'.
Thanks