Showing % of total share for top ten buyers

Showing % of total share for top ten buyers

Hi Guys 

I am trying to generate a report for Top 10 buyers and using the default Top 10 filter. But when I try sum > % of total, it only considers share among the top 10. 

I want to show the buyer's share of the total amount sold

E.g. 
Total Sales: 1M
Top ten Buyer total sales: $500K
Top Buyer sales: $50K

The chart should show the percentage of shares the buyer has as 5%, while the chart shows 10% because it takes the total of the top 10 based on the filter and not the sum of all buyer amounts. 

I tried multiple things in the chart, but I'm not sure how to overcome this.

Any input or details of what can be used would be very helpful. 




      • Sticky Posts

      • Announcing Zoho Analytics 6.0 Beta!

        We are delighted to open up the next major version, Zoho Analytics 6.0 Beta! The new version comes packed with a wide range of functionalities for all persona, namely business users, data analysts, data engineers, and data scientists. Zoho Analytics team

      • What's New in Zoho Analytics - August 2024

        Hello Users! We are back with the latest updates and enhancements made to Zoho Analytics. Keep reading to learn more about them. Connect to the data hosted in the cloud without allow-listing the IP addresses Utilize Zoho Databridge to connect to the data

      • We are coming to your city! Zoho Analytics Community Meetup

        Hello, business leaders and data enthusiasts! We are delighted to announce that registrations are now open for the ZUG meetups, and we can't wait for you to be a part of them. Our in-house analytics experts are geared up to lead discussions on constructing

      • Zoho Analytics: 2021 Look Back

        As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021

      • [Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022

        Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution.  Hear more from Claudio Cabeza, Director at PREMO