Filter data in pivot tables and charts with slicers

Filter data in pivot tables and charts with slicers

At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add, edit, customize, and delete options.


How do slicers differ from usual filters?


Spreadsheet filters are handy to sort relevant data from an extensive data set. While traditional filters are applied as drop-downs within the table, slicers are prominent graphical elements with buttons that you can place anywhere inside the sheet. 


Establish multiple pivot connections


Slicers allow you to establish connections between multiple pivot tables in your spreadsheet, allowing you to filter and analyze data simultaneously, provided the tables share the same source data. You can choose to add or remove connections at any time.


Personalize your slicers


Like every other object in Zoho Sheet, you can customize slicers and their buttons based on the layout, height, weight, and font, and smartly align with other objects in your spreadsheet.



Slicers are useful, especially when multiple pivot tables are connected, in building interactive spreadsheet dashboards.

Try the new slicer option in Zoho Sheet and tell us your feedback. Follow our community to receive all the latest product-related announcements and updates.


      • Sticky Posts

      • Feature enhancement: Highlight rows based on a cell value

        Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw
      • Create and save user-specific filter views with Zoho Sheet

        The filters in Zoho Sheet have become even more collaboration-friendly. Previously, whenever you filtered any data, the filtered view will be updated for all the spreadsheet collaborators. This disturbed the data for others working on the same file. With this new update, you can apply data filters without altering the view for other collaborators in the file.   Collaborate with user specific filters   Let us say you are working on a sales report spreadsheet in real time with two remote colleagues. If
      • Revamped Print in Zoho Sheet—customized for paper

        The latest enhancements to Zoho Sheet's Print settings allows you to print a worksheet or a selected range, with customizations that make the data comprehensible, even on paper.   Customize header and footer Make your spreadsheets meaningful with a relevant header and footer. You can now choose to display the file name, sheet name, current page number, total pages, date, and time as the header and footer in your print view. Besides the predefined elements, you can also give a custom text for header/footer.
      • Slicers are now available in Zoho Sheet—filter your data interactively

        At Zoho Sheet, we diligently track user requests and feedback. In line with this, based on extensive user requests, we've integrated Slicers to pivot tables and are delighted to announce its release. Slicers are interactive visual filters that have add,
      • Check out the new Checkbox in Zoho Sheet

        Checkbox, the simple GUI widget that lets you choose between two mutually exclusive options i.e Yes or No, is now in Zoho Sheet. Having made it across the web, Checkbox is familiar but is still elusive to most spreadsheet software. Special developer ribbons, macros and all other complexities to add a checkbox to a spreadsheet? Not in Zoho Sheet. How to add Checkbox to Zoho Sheet? Adding a Checkbox in Zoho Sheet is simple. Select a cell/range and choose "Checkbox" in "Input Controls" under the Format

        • Recent Topics

        • New Asap Widget How to update my code

          I know you're still working on updating the documentation for calling the Asap Widget, the existing documentation is no longer valid. In the old 1.0 version I was able to do many things programmatically in javascript. I could open an article directly
        • Whatsapp groups support

          Hi Can we use whatsapp groups with zoho desk I have managed to link whatsapp channel , howeer when i connect my whatsapp number in a group, it does not trigger a ticket in zoho desk. thank you
        • Preventing auto-redirect to Parent Record on Save...

          Our users often create records from the related list on th left side of the screen. They click the blue "plus" button to create the record. This is handy, but for some modules, or situations, they would like to remain on the record AFTER clicking "Save",
        • how to create link between Zoho Form and Zoho Tables

          We use Zoho Form to collect data from clients, and how to set link to upload certain data to Zoho Tables automatically while a form is submitted. It will make the whole process effectively.
        • Forced Logouts - Daily and More Frequent

          In the last month or so, I've been getting "power logged out" of all of my Zoho apps at least daily, sometimes more frequently. This happens in the same browser session on the same computer, and I need to re-login to each app separately after this happens.
        • Atualização que agora me lascou!

          Bom dia a todos! Recentemente a Zoho lançou uma atualização que permite edição do Subformulário de Itens Cotados na página de detahes do orçamento. Isso está acontecendo demais minha vida pois tenho várias funções nas quais o gatilho de funcionamento
        • Zoho CRM Roles to Zoho Desk

          I have created my role hierarchy in Zoho CRM, Can i import/sync those roles from CRM to Desk or should i create role hierarchy again in Desk?
        • Trip form, how to update a custom field

          We have a very basic trip form, that contains these custom fields: Hotel Cost Airline Cost Total Cost (read only) When someone enters a value into "Hotel Cost" or "Airline Cost" we simply want to sum them and update the read-only "Total Cost" field. How
        • Multi-currencies in Zoho Books

          I'd like to request multiple currencies in Zoho Books. I have customers paying in USD, CAD, CNY. I need to bill customers in these currencies too. I can set up a base currency, and then set up a exchange-rate table to convert these currencies.
        • This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details

          Hello, Just signed up to ZOHO on a friend's recommendation. Got the TXT part (verified my domain), but whenever I try to add ANY user, I get the error: This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details I have emailed as well and writing here as well because when I searched, I saw many people faced the same issue and instead of email, they got a faster response here. My domain is: raisingreaderspk . com Hope this can be resolved.  Thank you
        • Client Side Scripts for Meetings Module

          Will zoho please add client side scripting support to the meetings module? Our workflow requires most meeting details have a specific format to work with other software we have. So we rely on a custom function to auto fill certain things. We currently
        • Zoho marketing hub integration with WordPress WooCommerce

          Hello All,  I am a Zoho One User and we are using Zoho Marketing Hub we also have a website on Wordpress and we use Woo Commerce as our store.  im looking to find out if Zoho Marketing Hub Integrates with WooCommerce   ideally we would like to create Journeys or campaigns series based on customer behavior such as buying or already have purchased specific products. or if they go to the store but don't buy (abandon cart follow)  i saw that there is a wordpress plugin for Zoho Campaigns https://wordpress.org/plugins/zoho-campaigns/ but
        • Integration with Zoho CRM?

          Will it be possible to integrate WorkDrive with CRM similar do Zoho Docs?
        • Update ticket via import.

          Hi Zwitch team imported my tickets from freshdesk. Nice job but there is 2 pb 1st: we made mistake in agent email then ticket of this agent are unassined after zwitch import 2nd : zwitch does not take time entries. Then I got an idea. I exported from
        • Make function for repeating code

          Hi, It's me again with my questions... 😅 In my Creator app, there's code that repeats itself in several places. And repeating code necessarily means optimization. So I'm trying to create a custom function to centralize my code in a single place and call
        • Last activity time is acting like last modified time

          When i edit the description or any field in the potential, account, contact and lead, the Last Activity Time is being updated like the Modified Time. This is messing all workflows and reports and we are unable to track real last time of activities like mentioned in this KB article http://crmkbase.zoho.com/what-is-the-difference-between-record-modified-time-and-record-last-activity-time
        • Make collecting payments from your customers in Bigin easier with payment links

          Greetings, Efficient payment collection is crucial for business success. Bigin already helps your businesses manage and sell products effectively, but we can further enhance this by making payment collection easier. This integrated payment feature lets
        • Do "shortcuts" or symlinks exist in Workdrive?

          I need some kind of link or shortcut to put into folders that point back to original files or folders, is there any way in Workdrive to do this?
        • Line chart customization

          Hi, is there any way to draw multiple lines on a single line chart. Now on te x-axis im displaying dates and on the y-axis dispalying total records count. I want to display multiple lines on the same chart. The sample image is attached
        • Kaizen #91: Dynamic Lookup filters using Client Script

          Hello everyone! Welcome back to another captivating Kaizen post. In this post, we will explore the process of implementing lookup filters using Client Script. What is a dynamic lookup filter? A dynamic lookup filter is a feature that allows you to specify
        • Deluge Function to Update Custom Field

          I'm trying to get a Deluge function (which will run as part of a Schedule in Desk) that retrieves all tickets with the status "Recurring" and updates the custom field checkbox "cf_recurring" to "true". Here's what I have, which doesn't work: searchValue
        • How to join a meeting?

          One to one calls work perfectly fine within Trident. Though I see no option to initiate or join a scheduled multi-user meeting there. If a meeting is already in progress then a click on "Join Meeting" buttons takes me to the browser instead of joining
        • Sorting in scorecards

          Hi Can I request the addition of a Sorting feature in the Scorecard widget? We use this to show account manager performance by quarter, or year, or whatever. It's good for side-by-side comparisons. However, it would be more useful if we could choose to
        • CRM

          I have a portal set up where a contact can see other contacts within an account automatically. When a contact in the portal enters a deal, how do I make sure that deal is assigned to the account so other contacts in the account can see the deal was generated?
        • Embedding social media feed into a website

          Are there any tools or widgets available from Zoho that will allow embedding live social media feeds to a website?
        • Issue with syncing zoho campaigns with zoho crm

          Hi there, I want to sync both zoho campaigns with zoho crm however i have encountered some issues with this. when clicking manage in zoho i receive this message even though im using the same account and its an admin account. however when i go to zoho
        • Unable to deregister VAT

          Hi All, My business turnover is below GBP 80,000 and HMRC approved my cancellation for the VAT. However, I am not able to cancel the VAT mapping in the Zoho book. As I should not display it in my company's official document if my company does not have
        • Base Currency Adjustment - Mark Transaction as Something Other than Unreconciled

          Not a very concise title, but it describes the issue pretty well. Basically, when a Base Currency Adjustment is made, the transaction is recorded in the register of the account in question (as it should be). It's marked as "Manually Added", which makes
        • Presence of draft messages are not obvious

          I can't count how many times this has happened to me.  It's at least 20 or 30 times. I go to compose a message to a customer on a ticket, I think I hit "send" but maybe it didn't register, or I moved off the tab for another task and then closed the tab
        • Please Add StatusIQ to Zoho One

          Hi Zoho One Team, I hope you're doing well. We would like to request the inclusion of Zoho StatusIQ as part of the Zoho One suite. Since StatusIQ is already a Zoho product, integrating it into Zoho One would provide organizations with a powerful tool
        • Chromium: On open Writer document , Aw Snap

          Opening Writer document does not work in Chromium browser. On open any document, it appears for the moment, then disappear with Aw Snap! Something went wrong displaying this message. Error code: RESULT_CODE_KILLED_BAD_MESSAGE Chromium: Version 136.0.7065.0
        • Zoho DataPrep: Data Type Does Not Match Column in the Target - Dates

          We are attempting to add a last order date to our customers in Zoho CRM that is pulled from a google spreadsheet. This is the test data fields we are using. When we import into Zoho Dataprep, we get this error. After checking the formatting, it appears
        • How to do the equivalent of object.Parent.Grandparent.Field in Creator?

          I have a form with a parent form and I frequently want to access the parent form data from the UI. One concrete example is an Inventory report. The Inventory has a Product and the product has a classification. I would like to display inventory.Product.Classification
        • Ask the Experts 18: Supercharge Self-Service: Simplify Support, Empower Customers!

          Welcome to the Ask the Experts Session 18 focusing on Zoho Desk’s Self-Service features! With the AI buzzing around like busy bees, ever thought of how you can incorporate AI into Self service? Explore how Zoho Desk's Help Center, Knowledge Base (KB),
        • Possible to filter out contacts that hasn't opened emails in Cadence?

          We use Cadences in various outreach - is it possible in analytics or reports to filter out the contacts that have not opened their emails?
        • how to get the status of customer in the customer portal using deluge script

          From the knowledge I knew, thisapp.portal.profileForUser(); This script able to get the permission of the customer. But, how to get the status of customer (the status I referred is Approved Customer, Pending Customer and Unconfirmed Customer) using the
        • Zoho Finance Workshop 2025 is Happening Now!

          Hello everyone! 👋 We’re thrilled to announce that the Zoho Finance Workshop 2025 has officially started, and we've already wrapped up the event in Chennai, our home ground! After an amazing session, we're geared up to visit more cities in India and take
        • Zoho Inventory: Get Items with sotck on hand in different warehouses in a single shot

          Hello, Is there a way to get all the items with their stock properties per warehouse in a single API call? I'm trying to use this: https://inventory.zoho.com/api/v1/items?organization_id=organizationId it's returning: "item_id": "2767260000000074112",
        • Social Selling: LinkedIn Unified Inbox within SalesInbox

          Can you add LinkedIn Unified Inbox to CRM SalesInbox - this would enable managing LinkedIn Connections Messaging Directly from SalesInbox - adding leads, creating contacts and or potentials within CRM from Linkedin conversations Examples of LinkedIn inbox
        • Collapsible Sections & Section Navigation Needed

          The flexibility of Zoho CRM has expanded greatly in the last few years, to the point that a leads module is now permissible to contain up to 350 fields. We don't use that many, but we are using 168 fields which are broken apart into 18 different sections.
        • Next Page