Exclude Reporter Groups from the All Reporter Groups group

Questions & Answers
1

I am calculating the Issues Created Count using Reporter Groups
I am currently using

  • All Reporter Groups
  • dl NPI Dev (this is distribution list)
  • dl NPI QA

When the data is generated, the All Reporter Group includes the dl NPI Dev and dl NPI QA groups.
See example table

All Reporter Groups dl NPI Dev dl NPI QA
6/1/20 22 6 1
6/2/20 15 7 2
6/3/20 32 9 1

How do calculate a group that includes all groups except the dl NPI Dev and dl NPI QA groups.
I would expect a table like below

Other Reporter Groups dl NPI Dev dl NPI QA
6/1/20 15 6 1
6/2/20 6 7 2
6/3/20 22 9 1
2

Bumping this to see if can get some help from the community or the @eazyBI-Staff

3

Hi @jgibson

You may want to create a calculated member in Reporter Groups dimension with all but those two groups using function Except() as described here: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/except

The formula could be the following:

Aggregate(
  Except(
 [Reporter Group].[Group].Members,
 {[Reporter Group].[dl NPI Dev],
  [Reporter Group].[dl NPI QA]}
 )
)

Use correct member names in the calculation!

Then, in the report, use this calculated member instead of “All Reporter Groups”!

Ilze / support@eazybi.com

4

Perfect.
Thanks very much ilze