Forum Discussion
Solved
Cubeset with multiple Period range?
Hey All! need help with creating a Cubeset formula! I've market data at region level for multiple period & brand! I want to know the rank of particular Brand in each region on Specific Period. Formul...
kalpesh07 , Try using
=CUBESET(
"ThisWorkbookDataModel",
"EXISTS([Brandmaster].[Brand].children,
([State_Master].[State].[Maharashtra],
{[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]}))",
"Set",
2,
"AGGREGATE({([Measures].[S_Value],[State_Master].[State].[Maharashtra],{[Calendar].[Month].[Oct-2024]:[Calendar].[Month].[Dec-2024]})}, SUM)"
)
Hi kalpesh07 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.