# Aggregating Fix Versions

**URL:** <https://community.eazybi.com/t/aggregating-fix-versions/3209>\
**Category:** Questions & Answers\
**Tags:** calculatedmembers\
**Created:** [November 19, 2019, 2:53am UTC](https://community.eazybi.com/t/aggregating-fix-versions/3209 "2019-11-19T02:53:29Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![zane.baranovska](https://community.eazybi.com/user_avatar/community.eazybi.com/zane.baranovska/32/7209_2.png) [@zane.baranovska](https://community.eazybi.com/u/zane.baranovska)\
**Post date:** [November 26, 2019, 4:01pm UTC](https://community.eazybi.com/t/aggregating-fix-versions/3209/2 "2019-11-26T16:01:52Z")

</div>

Hi @pankajmehta,

The natural way to group Fix Versions by Deployment would be to set the **Deployment** dimension on rows. At the same time you can use Deployment dimension as page filter as well ([https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Pagedimensions](https://docs.eazybi.com/eazybijira/analyze-and-visualize/create-reports#Createreports-Pagedimensions))

If this is not an option for you because data between **Fix Version** names and **Deployment** dimension does not match this way, you may create **calculated members** in the Fix Version dimension (as you already suggested). To group fix versions by name pattern, you might want to filter versions using operation **MATCH** and **regular expression** of a pattern.

For example, to group fix versions that start with 3.(0.5) the calculated member might look like this:

```
Aggregate(Filter(
  [Fix Version.By name].[Name].Members,
  [Fix Version.By name].CurrentHierarchyMember.Name MATCHES "3.(0.5).*"))

```

Make sure that hierarchy `Fix Version.By name` is the same for calculation and calculated member name (see picture below).

 ![image](https://community.eazybi.com/uploads/default/original/2X/8/8a3a45d319f7cc1f8318a6c3017f24b7f19fd6f2.png)

More details on regular expressions are here:  
[https://docs.eazybi.com/eazybi/analyze-and-visualize/regular-expressions](https://docs.eazybi.com/eazybi/analyze-and-visualize/regular-expressions)

Best,  
Zane / [support@eazyBI.com](mailto:support@eazyBI.com)

---

_[View the full topic](https://community.eazybi.com/t/aggregating-fix-versions/3209)._