# Pivot table average

**URL:** <https://community.eazybi.com/t/pivot-table-average/19952>\
**Category:** Questions & Answers\
**Tags:** eazybi, mdx\
**Created:** [May 7, 2025, 12:44am UTC](https://community.eazybi.com/t/pivot-table-average/19952 "2025-05-07T00:44:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Patricio\_Gonzalez](https://community.eazybi.com/user_avatar/community.eazybi.com/patricio_gonzalez/32/12579_2.png) [@Patricio\_Gonzalez](https://community.eazybi.com/u/Patricio_Gonzalez)\
**Post date:** [May 7, 2025, 12:44am UTC](https://community.eazybi.com/t/pivot-table-average/19952/1 "2025-05-07T00:44:18Z")

</div>

Hi my name is Patricio, I need please if you can help me with something that I have not been able to do.

I need to get the total average, in this example it gives me 2.12 average in the header because it calculates all the release details of each project, but I just want to average the totals of the pivot table (1+2.5+1+2.72+2.58 = 1.96) so that this 1.96 is shown in a panel as a single value.

 ![image](https://community.eazybi.com/uploads/default/original/2X/3/37549f122bb51bb9f4d6cc0702bd8d77006cdb34.png)

How do I want to show this value:

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

Is this possible?

Thank you very much for your help  
Patricio

---

<div class="post-metadata">

**Author:** ![ilze.leite](https://community.eazybi.com/user_avatar/community.eazybi.com/ilze.leite/32/19_2.png) [@ilze.leite](https://community.eazybi.com/u/ilze.leite)\
**Post date:** [December 3, 2025, 9:54am UTC](https://community.eazybi.com/t/pivot-table-average/19952/2 "2025-12-03T09:54:42Z")

</div>

Hi @Patricio_Gonzalez

You may want to create a calculation that, for the All Fix Versions row, returns the average of _Average resolution days_ for displayed rows, using [ConstantColumnValue](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/constantcolumnvalue) and [VisibleRowsSet](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/visiblerowsset) funcions, while the rest of the rows display the standard _Average resolution_ _days_ value.

The calculation would be the following:

```auto
Case when
  [Fix Version].CurrentHierarchyMember is [Fix Version].CurrentHierarchy.DefaultMember
THEN
 CASE WHEN NOT IsEmpty([Measures].[Average resolution days]) THEN
  ConstantColumnValue(CatchException(
    Avg(VisibleRowsSet(), [Measures].[Average resolution days])
  ))
 END
 ELSE
  [Measures].[Average resolution days]
end

```

Note: if you expand project-level rows, the average for the total row in this case changes.

Best,

Ilze, [support@eazybi.com](mailto:support@eazybi.com)