Mike_Alex
New member
I have a cubeset formula that I am trying to use a slicer in but not sure of how to write. Here is my current formula (that works, but want to change the date cell to a slicer)
("topcount(({[Item Grouping - Item ID].[All].[Dining Room Chair].children,[Item Grouping - Item ID].[All].[Dining Tables].children}),20,sum(([Time Periods].[Descriptive Fiscal Periods].[Fiscal Day].&["&'Report Format'!$B$3&"]),[Measures].[Written Sales]))")
Formula works fine, but I want to change the cell location in B3, to be a slicer instead, such as:
("topcount(({[Item Grouping - Item ID].[All].[Dining Room Chair].children,[Item Grouping - Item ID].[All].[Dining Tables].children}),20,sum((slicer_time_periods),[Measures].[Written Sales]))")
Anyone who may have an idea? I have tried using the Time Periods .& and the the slicer to no avail, and also Time Periods ["&Slicer&"], but also does not work.
("topcount(({[Item Grouping - Item ID].[All].[Dining Room Chair].children,[Item Grouping - Item ID].[All].[Dining Tables].children}),20,sum(([Time Periods].[Descriptive Fiscal Periods].[Fiscal Day].&["&'Report Format'!$B$3&"]),[Measures].[Written Sales]))")
Formula works fine, but I want to change the cell location in B3, to be a slicer instead, such as:
("topcount(({[Item Grouping - Item ID].[All].[Dining Room Chair].children,[Item Grouping - Item ID].[All].[Dining Tables].children}),20,sum((slicer_time_periods),[Measures].[Written Sales]))")
Anyone who may have an idea? I have tried using the Time Periods .& and the the slicer to no avail, and also Time Periods ["&Slicer&"], but also does not work.