Pivot Chart - Zoho Creator

Pivot Chart - Zoho Creator

In Zoho Creator, I want to enable an edit option within the Pivot Chart itself. Additionally, I want to avoid showing duplicated values for certain columns.

For example, I’ve created a month-wise sales report for each product type. The form contains fields like Month, Product Type, Region, Total Sales, and Units Sold.

Now, I want to display the Region and Product Type as column headers, followed by the Total Sales and Units Sold for each selection. For instance, if I select January and Type A, with 500 Total Sales and 10 Units Sold, I don't want to repeat these values for the same combination.

Also, I want to enable the edit option in the Pivot Chart itself.


How Can I do this?

    • Sticky Posts

    • Share your success story

      We would like to hear from our passionate users how much Zoho Creator has changed the way you work and benefited you. If you would like to share your story to us and be featured as a proud user of Zoho Creator, then this is for you. Fill up the form below and if you want to be included in a case study, we will get in touch with you to get further details. So what are you waiting for? Tell us your story. Charles

    • Merge and Store v1 API depreciation

      Hi Zoho Writer users, The Merge and Store v1 API allows you to store the merged document in Zoho WorkDrive. The response of this API will be returned with the document's ID only after the merge is complete. In Deluge, the maximum timeout for operation

    • Zoho Creator Developer's Conference 2017 !!!

      We welcome all our Creator Developers! You're invited to join us for our annual Zoholics Developers conference August 29th–31st! This is your chance to get training and guidance on Zoho Creator from our most knowledgeable custom app builders.       Zoholics Developers is a three-day event where you'll participate in interactive workshops to hone your app-building skills, get questions answered by Creator experts with personal one-on-one sessions, and connect with other Creator developers from around

    • Recent Topics

    • Zoho Desk : How to Filter Tickets by @Domain or Email Address

      Hi Zoho Desk Support Team, I would like to know how to filter tickets by a specific @domain or email address in Zoho Desk — not by Contact Name. For example, is it possible to search or create a view that shows all tickets from a particular domain (e.g.,

    • Zoho Desk: Quick Filter/Quick Search InputBox in Ticket View

      Hi Zoho Desk Developer Team, I would like to suggest adding a “Quick Filter” search box in the Ticket View page. It would be very helpful, We can search for it immediately by ticket title, email, sender name, or ticket ID directly from the view. This

    • Zoho Analytics UI Bug

      Hello, all, The Aggregate Formulas in Zoho Analytics' list of fields have a 3-dot menu: If the formula has a long name, the name is not fully visible in the list, and a 3-dot menu is not accessible from it: This is not convenient, especially when the

    • [Free Webinar] Learning Table Series June 2026 - Mobile-first field operations with Zoho Creator

      Hello everyone, We’re excited to announce the next session in Learning Table Series 2026, where we will continue with our purpose-driven approach—focusing on how Zoho Creator’s features help solve real-world business challenges. Each session in this series

    • How to handle email attachments >5MB from Zoho Mail to Zoho Creator via Zoho Flow?

      Hi Zoho Community, I'm building an email management system that automatically captures incoming emails from Zoho Mail into Zoho Creator records via Zoho Flow. Everything works fine except for one major blocker — email attachments larger than 5MB. Current

    • Is there a way to add custom fields to Company Details?

      Hi Zoho community, I'd like to store a bunch of custom related values (eg registration date, paid up capital etc) in CRM. Please note I'm talking about my own company not clients. I dont want to pollute Account module with irrelevant fields since i want

    • Spotlight Series #28: Power up your Mac presentations with Apple Intelligence

      Hello, Mac users! This month's spotlight is for you. Zoho Show's desktop app for Mac just got a whole lot smarter, and we think you're going to love what's inside. Apple Intelligence is now built directly into Zoho Show for Mac, not as a sidebar, not

    • Reach us through our official support channels

      Dear Customers, Thanks a lot for choosing Zoho! Our applications are built to help achieve your day-to-day business goals. We are committed to engaging with you, to understand and develop solutions that enhance your productivity. We are happy and ready

    • Zoho Desk / Assist Integration

      Good day, We use both Zoho Desk and Assit, and were wondering if there is a way to schedule a remote session from within Desk. I know Desk has the "Remote Assist" option, but even that is not the most user-friendly process. Or even if there is a way to

    • 5 dashboards no Zoho Analytics que transformaram a gestão dos nossos clientes

      Nos últimos anos, implementamos o Zoho Analytics em empresas dos mais variados segmentos: varejo, saúde, jurídico, logística, SaaS. E uma coisa é certa: os CEOs que passam a ter dashboards em tempo real tomam decisões de uma forma completamente diferente.

    • #8 Your First Invoice for Real This Time

      Imagine standing at the edge of a journey you have carefully prepared for. Every setting configured, every detail arranged, every piece of your invoicing workflow thoughtfully put into place. What began as less than 30 minutes of setup has now transformed

    • Resolved (11:52am CDT): Uploading Files into Zoho CRM (US DC)

      Hello, Enterprise Support Community, We have begun receiving reports of issues with uploading files into Zoho CRM in our US DC, with file uploads failing during the upload process. Our teams are currently actively engaged in diagnosing and troubleshooting

    • GLM 5 not available

      Hello, I am trying to setup a Zia Agent using agents.zoho.com. The settings says that GLM5 is among the list of free zoho hosted models available. However, when I try to setup an agent and pick a model from the list only GLM 4.7 Flash is available. How

    • Zia Agent built in ChatKit UI does not render markdown

      Hi, You have a major shortcoming in the Zia Agent UI. The test UI that is embedded in agents.zoho.com allows you to test the agent has full support for rendering markdown, but your ChatKit UI does not have support for rendering markdown. If I embed it

    • Using gift vouchers

      We would like to be able to offer a limited number of gift vouchers, of varying values, to our customers, and are looking for the best way to do this. We have looked at Coupons and Gift Certificates, but neither seem to fit the bill perfectly. Coupons:

    • BUG: Related List Buttons with Client Script action now erroring

      There appears to have been a bug introduced over the last few days with Related List buttons that invoke a Client Script action. Button configuration: Configured Client Script: Results: The default loader is presented at the top of the page, and an error

    • Function #4: Schedule Customer Statements

      Regularly sending statements to customers is an imperative part of many business processes as it helps foster strong customer relationships and provides timely guidance on payments. While you can generate the statement of accounts and have it sent over

    • List of Contacts/Leads with Scheduled email

      Hi, I was wondering if there is way to derive a list of contacts/leads for whom emails have been scheduled in Zoho CRM Can we use filter for this? If yes then which and How? Regards, Karan

    • Account Reconciliation via API

      I am suggesting that the Zoho Books team considers making it possible to do an Account Reconciliation via API. The use case I have in mind is specific, but also fairly common: merchant services clearing accounts. Currently, the only way to reconcile an

    • Get item's custom field data for a custom button/function

      Hi, I’m working on a custom button for the Invoice details page in Zoho Books. I need to calculate a Tourism Levy only on some items. I already created an Item custom checkbox field: cf_tourism_levy In Zoho UI, the field is there and I can see it on the

    • Writer to Self Hosted Wordpress Posting without styling

      I have set up Writer to be able to post to my self-hosted wordpress website. The posts come through fine. However, they are including all of the styling from the Writer document.  This creates "inline" css code in my blog posts.  This is not a good situation for SEO and site speed.  I tried to match the site styles, but this still brings in the code as inline.  I tried entering HTML on the Writer document, but it just brings in the code as actual text.  So, instead of <strong>bold text</strong> 

    • Can I create a CODE 128 custom field for my items in Zoho Inventory and then use it for generating Sales Orders?

      Can anyone helps me, I don't want to use the SKU code for scanning my products.  ​Because all my products have a CODE-128 label attached.

    • Critical EU Server Routing Mismatch: Office 365 Graph API & IMAP OAuth Integration Failing with URL_RULE_NOT_CONFIGURED / AADSTS65005

      Hello everyone, Environment Details Subscription: Zoho One Data Center / Server: EU 1. Initial Office 365 Integration within CRM Attempt via Graph API When trying to integrate Office 365 into Zoho CRM via the Graph API for the first time, the process

    • Google Calendar Import in Wrong Time Zone

      Anyone else have this problem?  Google Calendar is only importing my events in "(GMT+00:00) Dublin" time, rather than Central Time.  For the life of me, I can't figure out how to get it to import properly. How can I fix this?

    • Microsoft Teams now available as an online meeting provider

      Hello everyone, We're pleased to announce that Zoho CRM now supports Microsoft Teams as an online meeting provider—alongside the other providers already available. Admins can enable Microsoft Teams directly from the Preferences tab under the Meetings

    • Zoho Mail Android and iOS app update: Classification labels

      Hello everyone! We are excited to introduce classification labels on the Zoho Mail mobile app. This is designed to protect sensitive emails with policy-based access and permissions. Classification Labels enforce secure access by restricting email visibility

    • Set Custom Icon for Custom Modules in new Zoho CRM UI

    • Zoho RPA named a Leader in the 2026 RPA Technology Value Matrix by Nucleus Research

      Zoho RPA has been named a Leader in the 2026 RPA Technology Value Matrix, published by Nucleus Research, one of the most respected technology research and advisory firms in the industry. This recognition places Zoho among a select group of vendors that

    • Super Admin Logging in as another User

      How can a Super Admin login as another user. For example, I have a sales rep that is having issues with their Accounts and I want to view their Zoho Account with out having to do a GTM and sharing screens. Latest Update (27th April 2026): With the early

    • Client Software Now Requires Computer Admin Password

      Recently whenever a user tries to run ZohoAssist.exe so that I can remote into their computer, it requires them to put in the computer administrator password, meaning they can't connect to the remote session. Before, it would allow them to run the exe

    • Using Another Field Value for Workflow Field Update

      I'm trying to setup a Workflow with a "Field Update" action on the Lead module, but I would like the new value to actually be taken from a DIFFERENT Field's on the Lead record (vs just defining some static value..) Is this possible? Could I simply use

    • How can I see content of system generated mails from zBooks?

      System generated mails for offers or invices appear in the mail tab of the designated customer. How can I view the content? It also doesn't appear in zMail sent folder.

    • Please implement UAE Central Bank FX rates

      Hello, as I understand from your knowledge base, any UAE business account created from September 15, 2018 does not have foreign exchange rates fetched automatically. This is a serious inconvenience and I am not sure why ZOHO has not looked into the ways

    • matching vs categorizing credit card payment from bank account

      I have a checking and a credit card in my Banking accounts. When there is a card payment (basically, a transfer from one to the other), does it make a difference which one I categorize first, then match with the other? I noticed when looking at the checking

    • SalesIQ browsing and attaching files directly from Zoho WorkDrive.

      Hi Developer SalesIQ Team. I think It would be much easier if we could browse and send existing files from Zoho WorkDrive directly through the reply dialog. I checked the Integration menu, I don’t see Zoho WorkDrive listed there. I hope this feature can

    • Découvrez les fonctionnalités d’enregistrement IA de Zoho Webinar

      Des enregistrements plus intelligents, des suivis plus simples Les nouvelles fonctionnalités d’enregistrement basées sur l’IA de Zoho Webinar facilitent l’exploitation de vos webinaires après leur diffusion. Grâce aux Résumés, Transcriptions, Chapitres

    • CNY not converting to PKR in P&L In reports.

      Hello Zoho Support Team, I am writing to report a multi-currency reporting issue in Zoho Books that is causing my Profit & Loss report to display incorrect Cost of Goods Sold figures. ISSUE DESCRIPTION: I have vendors set up in CNY (Chinese Yuan) currency.

    • RouteIQ for Zoho FSM

      Beste, Zou wel top zijn dat we een RouteIQ hebben voor FSM aangezien we constant moeten zien wat de beste route is voor onze monteurs. Nu moeten we een speciale aparte programma hebben om de beste route te berrekenen voor onze monteurs aangezien de planning

    • Please remove IP from greylist

      Currently, our mailserver 62.138.185.41 is greylisted by Zoho's mailserver. Please remove it from the greylist or tell me how to do it myself. And while you're at it, remove 49.12.112.150 as well. This will be our future mailserver. May 22 13:46:44 mailer

    • Print a price list or price book

      Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more

    • Next Page