I have a bar chart which I have set up as a 100% stack with two dimensions:
...using the following calculation I can show the % of Employees (this all works fine):
=Count([Employee_Number])/Count(total<[Org_Level_1]> Employee_Number )
However I actually want to use a drill down group, but I'm unsure how to use the group within the expresson. The group consists of 5 fields within the organisation hierarchy i.e. Org_Level_1, Org_Level_2 etc; and the above calculation works obviously with the first level, but does not with the second.
Basically, how do I amend the calculation so that it flexes depending on the org level...
Your help is much appreciated...
Figured it out, and just in case anyone else wanted to know, using the same expression as above I just included all the org levels that appear in the drill down group i.e: