How can I add these issues together to clean up this table

Questions & Answers
1

Hi there,

I need some help trying to add these values together in the table so they would just be under and “other” field. Right now, because of the different ways to get issues into our queue, they come through as all different categorisations.

Screen Shot 2022-08-30 at 4.45.03 pm
Screen Shot 2022-08-30 at 4.45.03 pm794×320 38.2 KB

2

Hi @Sibel_Bjelke-Yilmaz
You can create two calculated members in your report, one with all “other” values and the second without “other” values.
Here is an example with my dimension “T-Shirt size”:
First:

Aggregate({
  [T-shirt size].[XL],
  [T-shirt size].[XXL]
})

Second:

Aggregate(
  Except(
    [T-shirt size].[T-shirt size].Members,
    {[T-shirt size].[XL],
     [T-shirt size].[XXL]}
  )
)

Then use them in the report, expand the one without ‘other’ values and remove the upper value if you want to see each member there:

Issues_-Jira_reports-_eazyBI
Issues_-Jira_reports-_eazyBI1490×1446 250 KB

best,
Gerda // support@eazyBI.com