1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Create a TopN list using Cubeset that responds to Slicers

Hello! for the life of me i cannot figuire out if its possible to create a TopN list based on slicers.

This is my attempt:
=IF(CUBESETCOUNT($A$47)=1,CUBESET("ThisWorkbookDataModel","TOPCOUNT([product_dim].[name].Children, 25, ([Measures].[m_sales_units_rolling], " & $A$47 & ", " & $A$48 & "))","SKU"),CUBESET("ThisWorkbookDataModel","TOPCOUNT([product_dim].[name].Children, 25, ([Measures].[m_sales_units_rolling], " & $A$48 & "))","SKU"))

which A47 being a cubeset of a slicer

and A48 being a cubeset of another slicer.

This is through powerpivot so that may be the issue.

Sorry if this made no sense but any help/ideas would be great. Thank you!

submitted by /u/BushDid2008
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article