# Show the difference in percentages between two entities in report

**URL:** <https://community.fibery.io/t/show-the-difference-in-percentages-between-two-entities-in-report/5881>\
**Category:** Get Help\
**Created:** [February 20, 2024, 12:04pm UTC](https://community.fibery.io/t/show-the-difference-in-percentages-between-two-entities-in-report/5881 "2024-02-20T12:04:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [February 20, 2024, 12:04pm UTC](https://community.fibery.io/t/show-the-difference-in-percentages-between-two-entities-in-report/5881/1 "2024-02-20T12:04:17Z")

</div>

I want to show the difference in percentages between January and February.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/f/f35394c1cee42e7c51dc894d2ee16d2dcb05b341.png)

Is that somehow possible in the report builder? Or do I need to create a formula in Fibery and then show that output in the report?

Thanks!

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [February 20, 2024, 12:07pm UTC](https://community.fibery.io/t/show-the-difference-in-percentages-between-two-entities-in-report/5881/2 "2024-02-20T12:07:11Z")

</div>

Try the DIFFERENCE function 🙂

---

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [February 20, 2024, 1:17pm UTC](https://community.fibery.io/t/show-the-difference-in-percentages-between-two-entities-in-report/5881/3 "2024-02-20T13:17:27Z")

</div>

> [@Chr1sG](#):
>
> DIFFERENCE

Thanks!

If I use that function, the difference (verschil) is shown in January

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/5/519b4ae9c7de6e73f894139352721e3380f54bab.png)

Is there also a way to show the growth in February? This is the formula that I currently use.

```auto
(DIFFERENCE(
	SUM([Actieve contacten])
) / SUM([Actieve contacten])) * 100

```

**EDIT**  
When I change the sorting, the values are also changing. But in this case I prefer to see 46% instead of 31.51%. Plus ideally I want to sort descending since it will be a lot of entities after a few years (and I rather show all entities then filter \<1 year entities)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/0/0176bb82ccd0914e354ebc057573a31d299e078a.png)

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [February 20, 2024, 1:56pm UTC](https://community.fibery.io/t/show-the-difference-in-percentages-between-two-entities-in-report/5881/4 "2024-02-20T13:56:33Z")

</div>

The DIFFERENCE function always works down the list, so it shows the delta when going from one row to the next row below.  
So I don’t think there is any way to have the sort order how you want and have the difference calculation how you want.  
By the way, have you considered using a chart instead of a table? You could have the months on the x-axis and the number of contacts as vertical bars (i.e. a histogram)  
Alternatively, you can add a filter to limit the data to the most recent 12 months…?

> [@YvetteLans](#):
>
> I prefer to see 46% instead of 31.51%.

Then I think you need a formula like this:

```auto
(100 * DIFFERENCE(SUM([Actieve contacten]))) / (SUM([Actieve contacten]) - DIFFERENCE(SUM([Actieve contacten])))

```

---

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [February 20, 2024, 3:37pm UTC](https://community.fibery.io/t/show-the-difference-in-percentages-between-two-entities-in-report/5881/5 "2024-02-20T15:37:22Z")

</div>

> [@Chr1sG](#):
>
> By the way, have you considered using a chart instead of a table? You could have the months on the x-axis and the number of contacts as vertical bars (i.e. a histogram)

Yes considered it but IMO a chart is not very user friendly if percentages are the most important metrics.

> [@Chr1sG](#):
>
> Alternatively, you can add a filter to limit the data to the most recent 12 months…?

I rather not since the overall growth for a longer period is also an important metric.

> [@Chr1sG](#):
>
> So I don’t think there is any way to have the sort order how you want and have the difference calculation how you want.

I create the metrics via a monthly automation. In that automation I now also calculate the difference and the percentage so I can avoid formulas and extra relations. And I use those values in the reports so that I can sort descending 😄

Thanks for all the help!