How To filter Issue Type(Dimension) so that two particular issue type are included as single column without aggregate.
How to do it?
I already have it
Aggregate({
[Issue Type].[Story],
[Issue Type].[Defect]
})
I don’t want it.
How To filter Issue Type(Dimension) so that two particular issue type are included as single column without aggregate.
How to do it?
I already have it
Aggregate({
[Issue Type].[Story],
[Issue Type].[Defect]
})
I don’t want it.
Hi,
you still would need a calculated member to display two members into one column.
Instead of Aggregate(), you may use a sum of those members in the calculation formula:
[Issue Type].[Story]+[Issue Type].[Defect]
Then this calculated member won’t be expandable.
Ilze (support@eazybi.com)