# The share percentage by row rathjer than columns

**URL:** https://community.piwik.pro/t/the-share-percentage-by-row-rathjer-than-columns/3714
**Category:** Reports and working with data
**Created:** [February 28, 2024, 10:11am UTC](https://community.piwik.pro/t/the-share-percentage-by-row-rathjer-than-columns/3714 "2024-02-28T10:11:06Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Terve](https://avatars.discourse-cdn.com/v4/letter/t/3ec8ea/32.png) [@Terve](https://community.piwik.pro/u/Terve)
#### Post date: [February 28, 2024, 10:11am UTC](https://community.piwik.pro/t/the-share-percentage-by-row-rathjer-than-columns/3714/1 "2024-02-28T10:11:06Z")

</div>

Hi, this is such a newbie question, but I didn’t manage to find any answers. I have made an explorer report for consent showing the consent form impression and consent types in columns and our different business units in the rows (custom dimension). By default, the system shows the percentage (share) by column, so I get what share of . e.g., consent form submissions for each business area. How can I show the percentage by row instead? I want to show the share of consent types per business unit. I know it is complex, as the first column (impressions) is almost the sum of the other columns. It seems the system is aware of this, as the first column is colored blue. Please see the attached screenshot

 ![Screenshot 2024-02-28 110418](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/2X/c/cb5df836f9fc28d7c12806d937ef5ae3711f4e0c.png)

---

<div class="post-metadata">

### Author: ![sararekowska](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/sararekowska/32/1582_2.png) [@sararekowska](https://community.piwik.pro/u/sararekowska)
#### Post date: [February 28, 2024, 1:34pm UTC](https://community.piwik.pro/t/the-share-percentage-by-row-rathjer-than-columns/3714/2 "2024-02-28T13:34:39Z")

</div>

Hi there!

We are not really able to change the little gray percentages, but you could create a [calculated metric](https://help.piwik.pro/support/reports/calculated-metrics/) that would show you the percentages of, let’s say, any consents in relation to impressions for a particular business unit. You can then use these custom metrics instead of the ones that are present in the screenshot.

---

<div class="post-metadata">

### Author: ![Terve](https://avatars.discourse-cdn.com/v4/letter/t/3ec8ea/32.png) [@Terve](https://community.piwik.pro/u/Terve)
#### Post date: [February 28, 2024, 3:54pm UTC](https://community.piwik.pro/t/the-share-percentage-by-row-rathjer-than-columns/3714/3 "2024-02-28T15:54:09Z")

</div>

Excellent suggestion, thanks.