Filter Story and Defect Issue Type without Aggregate

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
[Issue Type].[Story],
[Issue Type].[Defect]

I don’t want it.


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 (

1 Like