Distinct Count issue with Grand Total

Distinct Count issue with Grand Total

I have a Pivot Table report with a distinct count that is working fine going across the rows, but when it shows the Grand Total, i want it to sum the counts above it.  Right now it is showing something different.

This is made up data, but it represents my report.  This is a report showing each customer, and how many different brands they bought.  

Customer Name
Brand
Customer.Distinct Count
ToysRUs
Lego
1

Barbie
1

Hot Wheels
1
Walmart
Lego
1

Barbie
1
Target
Barbie
1

Hot Wheels
1



Grand Total

3

The Grand Total is currently showing '3' for the 3 different customers.  I need it to show the actual sum of the numbers above it, which would be 7.

If I change the Distinct Count field to be counting on the Brand Name field, it only shows me '3' also because there are 3 different distinct brands.  Any idea on how to get it to show 7?

    Access your files securely from anywhere








                            Zoho Developer Community



                                Bootcamp
                                Community
                                Pricing
                                Webinars
                                What's New
                                Integrations
                                Contact Support
                                Contact Sales
                                  Zoho Survey Resources
                                    Features
                                    Survey Templates
                                    Integrations
                                    Community
                                    iOS Mobile Surveys
                                    Pricing
                                    Android Mobile Surveys
                                    Insurvey Blogs
                                    Insight Blogs
                                    Tips & Tricks





                                                Latest Feature Updates

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                  • Ask the Experts




                                                      Zoho SalesIQ Resources

                                                            • Sticky Posts

                                                            • What's New in Zoho Analytics - January 2026

                                                              Hello Users! We are starting the year with a strong lineup of updates, marking the beginning of many improvements planned to enhance your analytics experience. Explore the latest improvements built to boost performance, simplify analysis, and help you

                                                            • What's New in Zoho Analytics - November 2025

                                                              We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's

                                                            • What's New in Zoho Analytics - October 2025

                                                              Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme

                                                            • What’s New in Zoho Analytics – September 2025

                                                              Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded

                                                            • Announcing Agentic AI - Ask Zia!

                                                              We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.


                                                            Manage your brands on social media
                                                            Access Zoho Social

                                                              Zoho Pagesense Resources


                                                                  Zoho TeamInbox Resources

                                                                    Zoho DataPrep Resources


                                                                      Zoho CRM Plus Resources

                                                                        Zoho Books Resources


                                                                          Zoho Subscriptions Resources

                                                                            Zoho Projects Resources


                                                                              Zoho Sprints Resources


                                                                                Qntrl Resources


                                                                                  Zoho Creator Resources



                                                                                      Zoho CRM Resources

                                                                                      • CRM Community Learning Series

                                                                                        CRM Community Learning Series


                                                                                      • Kaizen

                                                                                        Kaizen

                                                                                      • Functions

                                                                                        Functions

                                                                                      • Meetups

                                                                                        Meetups

                                                                                      • Kbase

                                                                                        Kbase

                                                                                      • Resources

                                                                                        Resources

                                                                                      • Digest

                                                                                        Digest

                                                                                      • CRM Marketplace

                                                                                        CRM Marketplace

                                                                                      • MVP Corner

                                                                                        MVP Corner









                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now


                                                                                            Zoho Show Resources

                                                                                              Zoho Writer

                                                                                              Get Started. Write Away!

                                                                                              Writer is a powerful online word processor, designed for collaborative work.

                                                                                                Zoho CRM コンテンツ



                                                                                                  Nederlandse Hulpbronnen


                                                                                                      ご検討中の方




                                                                                                              • Recent Topics

                                                                                                              • Notebook App Not Opening

                                                                                                                I love this app but for the last 2 days it recuses to open. My phone tells me the app is bugged and I must wait for a new update. Is anyone else having this problem or is something going on with me? I have many important notes that I can't necessarily

                                                                                                              • Admin and Dispatcher Users show as Field Technicians in Dispatch Module?

                                                                                                                Hi Zoho, Our Admin and Dispatch user both show up as Fied Technicians / Field Agents in the Dispatch module, but they most certainly should not be assigned to any of the work orders and service appointments. These users are NOT service resources. How

                                                                                                              • Copy Sales Order Reference# to Purchase Order#

                                                                                                                Hello, We use our customer's purchase order number as the order number on our purchase order to the supplier.  We direct ship everything from our suppliers and the customers then see their PO number on the packing notes (instead of a sequentially-generated one). Therefore, is it possible to use automation to copy the Sales Order Reference# (customer PO) to the respective Purchase Order# (our PO) when converting the Sales Order to a Purchase Order?

                                                                                                              • Free webinar: Zoho Sign in Q2 2025: A quick walkthrough

                                                                                                                Hi there! We’re halfway through the year—and Zoho Sign has some exciting enhancements to show for it! Join us in our upcoming webinar to discover what's new and what you can look forward to. What will this session cover? Explore the newest features introduced

                                                                                                              • Using a Webhook as an Action

                                                                                                                I have been able to setup where I can use a webhook as a Trigger, but I am wondering how I can use a webhook as an Action. In the Zoho Flow Builder when using Zoho CRM as a trigger, I do not see a way to invoke a URL to POST json data that can be used

                                                                                                              • Adding commas to a numeric value

                                                                                                                Hi, I want to add commas to numeric values so that they look like money E.g 1234.56 to 1,234.56 12345.67 to 12,345.67 12345678.90 to 12,345,678.90 How do you do that in Deluge? Thanks for the help

                                                                                                              • Tiktok and Instagram Carousel with Music

                                                                                                                Is it possible to add music or sound (can be downloaded or uploaded or attached) when we upload carousels in IG and Tiktok?

                                                                                                              • Once again, non-admins can no longer revise the site map

                                                                                                                Not sure when this change happened, but it's a problem now. This appears to be a regression on this issue: https://help.zoho.com/portal/en/community/topic/bug-non-admins-can-no-longer-revise-the-site-map ... which was solved. That issue was also a regression.

                                                                                                              • Detail View in Mobile without Labels

                                                                                                                Zoho creator 6. I have been trying to acheieve this but not able to. I have a quick view of my articles using custom layout for mobile. When i tap on an article it opens in detail view on my mobile which has two cols. Left displays label and right the

                                                                                                              • Updating task using excel file

                                                                                                                Hi, Is there a way to update existing tasks using excel file import?  Thanks

                                                                                                              • Cross module filtering is now supported in CRM

                                                                                                                Editions: All DCs: All Release plan: This enhancement is being released in phases. It is now available in AU, JP, and CN DCs. Help resource: Advanced filters The Cross-module filtering enhancement is now available to all CRM accounts in the following

                                                                                                              • Before Going To The Qc stage , site ready ness file upload mandtoty how to achive this in the blue print transition

                                                                                                                Before Going To The Qc stage , site ready ness file upload mandtoty how to achive this in the blue print transition On click of the Predelivery transition can we show site ready ness file upload mandtoty or on click of the QC show the alert message site

                                                                                                              • Note cards are duplicating

                                                                                                                Hi, I've been using this app for some time and love it. Recently I've noticed that upon closing a note card, it creates a duplicate. If I exit the notebook it's in and go back, everything is back to normal. Not a major issue but still a little annoying.

                                                                                                              • Where is the (Bulk) Notes Export function from Notebook ???????

                                                                                                                I have seen various threads over the last two years on this and basically no action from ZOHO at all ! BTW having to go to an individual note and export to PDF (which now doesn't even work ) or some sort of zoho format is by no means the answer ! I still can't see any sort of bulk (or even individual) export function across notes. This is really poor for a notes product that is nearly 4 years old from a "major vendor".  I now have a large number of notes (some with images) that I want to export and

                                                                                                              • Again about the backlighting of the search query when searching in a client for Linux

                                                                                                                Some time passed, I installed a client for Linux version 3.4.0, but I still did not receive the promised search with the backlighting of the search query how it was implemented in the client for android. In the previous topic, you told me that this function

                                                                                                              • Important! ZipRecruiter Sponsored Posting Plan Changes in Zoho Recruit

                                                                                                                Greetings, We’re reaching out to inform you about an important upcoming change to the ZipRecruiter Sponsored job board integration within Zoho Recruit. What’s Changing? Starting June 1, 2025, Zoho Recruit will be updated with ZipRecruiter's latest pricing

                                                                                                              • In the Blue Print Transition requirement received it will show 8 check field in pop up if they any one of this field then only move to next stage Ist quote

                                                                                                                In the Blue Print Transition requirement received it will show 8 check field in pop up if they any one of this field then only move to next stage Ist quote Pls help how i fix this

                                                                                                              • Convert Item to composite item

                                                                                                                When using Zoho CRM integrated with Zoho Inventory/Books, the item creation process is a little messy. After a few years of trial and error, we have settled on creating items in CRM, which are sync'ed to Zoho Inventory using Zoho's own internal integration.

                                                                                                              • Mapping “Account Name” from CRM to Campaigns

                                                                                                                I’m syncing our Contacts list to Campaigns and want to select “Account Name” as an available field. Account Name does not appear in the drop down menu for CRM field even though Account Name is a field in our standard layout. How can I make it availa

                                                                                                              • Zoho Campaigns to Zoho Analytics Sync Fails – Field Mapping Shows But Not Applied

                                                                                                                I’m facing a persistent issue with the Zoho Campaigns integration to Zoho Analytics in my workspace. Here’s a detailed description of the problem: Under Edit Setup, I see a field mapping summary that shows: DataField Mapping: Most Recent Login However,

                                                                                                              • Host in US Data Centre

                                                                                                                I humble apply to be registered on US Data centre

                                                                                                              • Multiple images, one record

                                                                                                                I have a form that is used to capture the following info: -Facility Name -Origin -Shipment # -Picture of Damaged Pallet (Image field) I want to be able to capture multiple pictures without having to create a new record, as there might be multiple damaged pallets on the shipment. Obviously, one never knows how many damaged pallets might be on a shipment so I'd prefer not to create 20 image fields and have most of them unused.  I'd prefer that they have an option to add another image only if they need

                                                                                                              • how to dynamically upload multiple images for single record?

                                                                                                                Is the use of dynamic multiple images in a single record supported? I've searched but have not found the answer. If it is supported, how is it done? I saw 1 suggestion to add a sub-form but that doesn't seem to be the answer. I don't want to add a set number of image fields. Each record would have a different number of images. I want the addition of images to be dynamic. thanks

                                                                                                              • Multi-upload field

                                                                                                                Hi I need to include a file upload field that allows the user to select multiple files and upload all at once. I hope I can do this with HTML, I'm new to merging HTML and deluge... Can I trigger a hidden file upload window to appear On User Input of a field in an embedded form? Thanks! Levi

                                                                                                              • is it possible to add multiple attachments to a record?

                                                                                                                Hello, I'm trying to add functionality so that a record can have several associated attachments. I obviously added a File Upload field to my form, but that appears to only allow one total. Is there a way around this? Thanks, - Kevin

                                                                                                              • multiple upload files in zoho form

                                                                                                                Hi,  I need upload multiple files  in a single upload field thkns

                                                                                                              • Keeping Track of Email Threads

                                                                                                                Hi, Z CRM is great for tracking all the activities one would want to track whilst qualifying leads, converting to customers, closing deals etc etc, however.... ....although I can use Z CRM to send an email to a lead/contact and have that recorded as an activity for other team members to see, there is no way of capturing an inbound email from that lead. Assume my lead replies to my email sent from ZCRM, in my case, the response arrives in my ZMail account. However I can't get it back into ZCRM to

                                                                                                              • Zoho Creator invokeUrl to retreive PDF

                                                                                                                I'm trying to retreive a record PDF to send to Print Node. Tried with and without the zoho_creator_connection. pdf_content = invokeurl [ url :"https://creatorapp.zoho.com.au/<org_namespace>/<app_link_name>/record-pdf/<report_link_name>/" + input.ID type

                                                                                                              • Zoho App Builder

                                                                                                                I’m looking for a Zoho Creator developer to build a simple app for tracking site expenses for a construction company. Key features: mobile form, dropdowns for projects and expense types, photo attachment for invoices, auto-calculated totals, and Excel

                                                                                                              • Captcha can't be enabled conditionally

                                                                                                                Hi Problem: captcha on a form can't be enabled conditionally. Why is this a problem: Because I use the same form on our website (public) in the portal and mobile app. In the portal it works but in the mobile app it doesn't. So there should be a way to

                                                                                                              • ACH Returns Don’t Trigger Dunning or Reverse Payment in Zoho Subscriptions

                                                                                                                Zoho Billing marked an ACH payment as successful and kept the subscription active — even though the payment was later returned by the bank (NSF). There was no update to the invoice or subscription status, and I had to manually clean it all up. For credit

                                                                                                              • Zoho Sheet - Split cell diagonally fill half color

                                                                                                                is it possible to split a cell diagonally, fill different text in each half and ideally color them differently as well?

                                                                                                              • Calling Token API in Postman returning "error: invalid_client"

                                                                                                                Hello, I've been working on setting up an API to get data from zoho crm into a third-party application. I'm currently testing the setup in Postman, but I'm getting an error from the API to retrieve the access token. It keeps returning "error: invalid_client".

                                                                                                              • How to handle this process need using a Blueprint?

                                                                                                                See one minute screen recording: https://workdrive.zohoexternal.com/external/eb743d2f4cde414c715224fc557aaefeb84f12268f7f3859a7de821bcc4fbe15

                                                                                                              • bulk scheduling youtube shorts and facebook reels

                                                                                                                how do i flag the video as facebook reel rather than normal video, it's vertical, 20 seconds, yet still being posted as video on facebook for youtube, it's being rejected out right both videos are to standard, can be posted normally with normal scheduler

                                                                                                              • Invitation-Based User Access in Zoho Analytics

                                                                                                                Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security

                                                                                                              • Filtert products by multi select custom field

                                                                                                                Hello, this is seems like a must addition, why it can not be done now?

                                                                                                              • Multiple images

                                                                                                                Hi Is there a way to insert multiple images in one image record or any way that instead of one image, I could upload 5 to 10 images together. Looking forward for a solution. Regards

                                                                                                              • Zoho Projects - Custom Objects

                                                                                                                Hello, is there the ability now, or in the near future, to add custom objects to Zoho Projects? The requirement here would be to have the ability to track change requests to a project's budget. The idea here is to have the ability to create a custom Object

                                                                                                              • Access CRM Variables from Formula field

                                                                                                                Is it possible to use a CRM variable (defined in Developer Space -> CRM Variables) in a formula field for calculations ?

                                                                                                              • Next Page