# Percentage of multiple dimension total

**URL:** <https://community.eazybi.com/t/percentage-of-multiple-dimension-total/19960>\
**Category:** Questions & Answers\
**Tags:** jira, eazybi\
**Created:** [May 8, 2025, 2:09pm UTC](https://community.eazybi.com/t/percentage-of-multiple-dimension-total/19960 "2025-05-08T14:09:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mefallit](https://community.eazybi.com/user_avatar/community.eazybi.com/mefallit/32/14168_2.png) [@mefallit](https://community.eazybi.com/u/mefallit)\
**Post date:** [May 8, 2025, 2:09pm UTC](https://community.eazybi.com/t/percentage-of-multiple-dimension-total/19960/1 "2025-05-08T14:09:11Z")

</div>

Hello,

I have 3 different Custom Dimension for XRAY. I’m trying to reach percentage of each project values like Android Done/Total. in this example: 165/264 so %62.5 is done. How can add this to one column?

 ![Screenshot 2025-05-08 at 5.05.35 PM](https://community.eazybi.com/uploads/default/original/2X/0/0ec1a5a8642d2f37f5b9c78c01fae0d6ac07feeb.png)

---

<div class="post-metadata">

**Author:** ![nauris.malitis](https://community.eazybi.com/user_avatar/community.eazybi.com/nauris.malitis/32/6355_2.png) [@nauris.malitis](https://community.eazybi.com/u/nauris.malitis)\
**Post date:** [May 15, 2025, 1:09pm UTC](https://community.eazybi.com/t/percentage-of-multiple-dimension-total/19960/2 "2025-05-15T13:09:40Z")

</div>

Hi @mefallit

For this, you can [create a new measure](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures) in the **Measures** dimension that will calculate the percentage value:

```auto
CASE WHEN
  [Measures].[Issues created] > 0
THEN
  [Measures].[Issues created]
  /
  (
    [Measures].[Issues created],
    [DimensionFromColumns].CurrentHierarchy.DefaultMember
  )
END

```

Be sure to use the real Dimension name instead of the `[DimensionFromColumns]` in the formula and set the **Formatting** to [Percentage](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Formatting).  
This formula will divide the current, for example, “Android DONE” issues created by all issues created (including other members from the dimension in Columns).

However, if you have selected only these four to report on (and you have a lot more members in the dimension in Columns), you can build a custom formula like this:

```auto
CASE WHEN
  [Measures].[Issues created] > 0
THEN
  [Measures].[Issues created]
  /
  Aggregate(
    {
      [DimensionFromColumns].[(none)],
      [DimensionFromColumns].[Android DONE],
      [DimensionFromColumns].[IOS DONE],
      [DimensionFromColumns].[Web DONE]
    },
    [Measures].[Issues created]
  )
END

```

​Best regards,  
​Nauris