I am looking for a way to display the distinct count of users based on the user type, in a cross tab, based on grouping displayed as a hierarchy is expanded. A user could be one of two types - and there needs to be a column for each type, for the distinct count of users of that type. Say, Type A, and Type B. Each user has a unique identifier and a type recorded, and can have multiple rows of data for each level of the hierarchy. The hierarchy in the cross tab, is: Financial Year -> Financial Year Quarter -> Residential State When the cross tab displays Financial Year, it is to display distinct count in columns for Type A, and Type B, for the Financial Year. Then, when hierarchy expands to Financial Year Quarter, it displays distinct count of Type A and Type B, for the Financial Year -> Financial Year Quarter. Then, when hierarchy expands to Residential State, it displays distinct count of Type A and Type B, for the Financial Year -> Financial Year Quarter -> Residential State.
... View more