# Can I ignore a holding in the Diversity Report?

**URL:** <https://community.sharesight.com/t/can-i-ignore-a-holding-in-the-diversity-report/448>\
**Category:** Sharesight features\
**Created:** [13 July 2021 13:41 UTC](https://community.sharesight.com/t/can-i-ignore-a-holding-in-the-diversity-report/448 "2021-07-13T13:41:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![gsyd](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gsyd](https://community.sharesight.com/u/gsyd)\
**Post date:** [13 July 2021 13:41 UTC](https://community.sharesight.com/t/can-i-ignore-a-holding-in-the-diversity-report/448/1 "2021-07-13T13:41:04Z")

</div>

I’d want a diversity report, but there’s a particular holding that I want to ignore, removing it from both the pie chart and the percentage calculations. So, basically I want to see my portfolio diversity _without_ this share.

Is there a way to do that?

---

<div class="post-metadata">

**Author:** ![ridoba](https://sea2.discourse-cdn.com/sharesight/user_avatar/community.sharesight.com/ridoba/32/123_2.png) [@ridoba](https://community.sharesight.com/u/ridoba)\
**Post date:** [13 July 2021 20:10 UTC](https://community.sharesight.com/t/can-i-ignore-a-holding-in-the-diversity-report/448/2 "2021-07-13T20:10:57Z")

</div>

Only way I can achieve that is by running the diversity report with “do not group”. Then click the button to export to excel/google sheets. Remove the unwanted holding, recalculate the grand total and then use a formula to work out the percentages in the spreadsheet. Sort of works and takes about a minute to do 🙂

---

<div class="post-metadata">

**Author:** ![Jack\_Sharesight](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@Jack\_Sharesight](https://community.sharesight.com/u/Jack_Sharesight)\
**Post date:** [14 July 2021 04:15 UTC](https://community.sharesight.com/t/can-i-ignore-a-holding-in-the-diversity-report/448/3 "2021-07-14T04:15:22Z")

</div>

@gsyd Welcome to the forum! @ridoba’s response is correct. There’s no way to visually exclude a holding from the report wholely.

You can also utilise [custom groups](https://help.sharesight.com/au/custom-groups/) to group all the investments you want to see, any you exclude or don’t group will just show in their own ‘uncategorised’ grouping.

---

<div class="post-metadata">

**Author:** ![gsyd](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gsyd](https://community.sharesight.com/u/gsyd)\
**Post date:** [14 July 2021 04:17 UTC](https://community.sharesight.com/t/can-i-ignore-a-holding-in-the-diversity-report/448/4 "2021-07-14T04:17:56Z")

</div>

Thanks for the replies. Not really keen to export to a spreadsheet as the whole reason I’m paying for Sharesight is to escape the spreadsheets! 😅

I’ll drop a little suggestion in the feature requests forum.

---

<div class="post-metadata">

**Author:** ![gsyd](https://avatars.discourse-cdn.com/v4/letter/g/9fc348/32.png) [@gsyd](https://community.sharesight.com/u/gsyd)\
**Post date:** [14 July 2021 04:26 UTC](https://community.sharesight.com/t/can-i-ignore-a-holding-in-the-diversity-report/448/5 "2021-07-14T04:26:09Z")

</div>

Written up here:

> [@Small idea: Option to ignore 'Uncategorised' in Diversity Report](https://community.sharesight.com/t/small-idea-option-to-ignore-uncategorised-in-diversity-report/451):
>
> • What feature do you want to see in Sharesight? When using the Diversity Report with Custom Groups, I’d like an option to hide ‘Uncategorised’ holdings, so that they don’t appear in the pie chart or in the denominator used to calculate the percentages. • Why do you want it? We have a particular holding which we don’t take into account as part of our target portfolio allocation mix. I want to see the Diversity Report using my Custom Groups, but with this holding excluded from the report entir…
