•1 min read•from 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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives
#TopN list
#slicers
#CUBESET
#CUBESETCOUNT
#ThisWorkbookDataModel
#TOPCOUNT
#product_dim
#m_sales_units_rolling
#powerpivot
#SKU
#formula
#data modeling
#Excel