Issue Summary: Would like to be able to sort with cube rank formulas on YTD periods
Description:
I would like to be able to sort with the cubeset and cuberankedmember formulas, like I do in the attached for a given month, for a given YTD period. Right now I can’t figure out how to do that and I suspect it is because the way I make a YTD periods is by creating a cubeset of the individual months. The cubeset formula won’t incorporate another cubeset formula within itself. My thought was to create YTD periods in the date dimension, but I’m open to other ideas too.
Issue Status: Issue Solved
Urgency: (2) Normal
Ticket Number: CAS-388972-J5K5M2
Email: dwallace@hotelbisolutions.com
Created Date: April 5, 2023
Last Updated: May 24, 2023
Resolution Note:
https://extranet.actusdata.com/wp-content/uploads/formidable/67/Cube-Rank-does-not-work-with-and-Cube-Set-YTD.xlsx