Need help on Rank function from Anapedia Result = RANK(Source, Direction, Ties, Include, Group) I have 2 group parameters for rank function (Parent(Product) and Parent(office)) but don't know how to include them both to formula in Group section
Current dimensions in the module are:
- Projects list (rolls up to a project category and then to a project manager)
- Months list (fake timescale)
- Line items
- Need to give each PM the ability to see their top 10 project variances.
I'm currently using the rank function and grouping it on the Months dimension but need the projects to be ranked individually for each PM and not for the entire Projects list.
Do you mind emailing me at [email protected]? I have a couple of screenshots I'd like to provide you with that might help clarify what it is I'm looking at.