So when using the Status member which is a smart list member of id numbers ranging from 1-11.
I am attempting to build an account member that depending what the status is flagged as it will provide a count of the number of members based on that rollup.
I currently have "Status Count" as the member I am trying to do this with. I have it as a never shared and never on the consolidation sign. I have a calc script with logic similar to this.
FIX("Current", "Working", &Current_Year, "LC", @LEVMBRS("Department",0), @LEVMBRS("Entity",0), "Product NA", @LEVMBRS("Location",0))
"Status Count"(
IF("Status"==1)
"Status Count" = @COUNT(SKIPBOTH,@RANGE("Status",@IDESCENDANTS("Employee")));
IF("Status"==2)
....
ENDFIX
You get the idea. Although I am running into issues.
1 - This needs to be on a report that I can show each of the 11 status members and then show what their count is at a specific department rollup point.
2 - I am not sure if I can show the status members in a column since those are only set to a level0 member unless on the FR report I set to grab only level 0 members of each dim.
Can someone help me with an approach to make this all plausible? I would greatly appreciate it.