Group data in a pivot table

Questions & Answers
,
1

Hi, I have a query if you can help me:

In JIRA I have a custom field called Area and in eazyBI I want to group it by Department (this last field is not in JIRA), is it possible to do this.

Example:
(JIRA field)
Area Department
IT Support —> IT
IT Development —> IT
Commercial —> Finance

Thank you very much for your help
Patricio

2

Hi @Patricio_Gonzalez,

You can Create calculated members to group Areas by Department.

In the Area dimension, define a new calcauted member for each Department. Use the Aggregate() function to group areas from the same Department. For example, the expression for IT department woudl look like this:

Aggregate({
  [Area].[IT Support], 
  [Area].[IT Development]
})

Please see the documentation for more details on calcauted members: Calculated members in other dimensions.

Best,
Zane / support@eazyBI.com