we have a structure like this Regional Manager (RM) -> District Manager (DM)
If a DM uses the application hs NAME is selected.
I must create an Region Gross Sales Average per District. the Gross Sales from the Region devided by the number of all District Managers in the Region.
I can get the number of DM'S with the getpossiblecount(DM_NAME) but only if the DM_NAME is not selected. And set analysis didn't work in this function.
Is there a posibility to get the correct number without a VBScript at the beginning?
Hi, have you tried to use a Count(distinct DM_Name) you can put it in a variable, once you select a region, the variable schould contain the number of DM which you can call on in your set analysis.
