Forum Discussion

kalpesh07's avatar
kalpesh07
Frequent Visitor
1 year ago
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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    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)"
    )

v-menakakota's avatar
v-menakakota
Community Support
1 year ago

Hi kalpesh07 ,

Thank you for helpful response bhanu_gautam ,I wanted to check if you had the opportunity to review the information provided by bhanu_gautam . Please feel free to contact us if you have any further questions. If this answers your question, please Accept it as a solution so other members can easily find it.

Regards,
Menaka.