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.

    Zoho Campaigns Resources

      Zoho Desk Resources

      • Desk Community Learning Series


      • Digest


      • Functions


      • Meetups


      • Kbase


      • Resources


      • Glossary


      • Desk Marketplace


      • MVP Corner


      • Word of the Day


        • Sticky Posts

        • 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
        • Format and analyze spreadsheet data with Zoho Sheet's Table

          While a spreadsheet helps you compile data for easy analysis, formatting helps make your data more comprehensible. We are happy to announce the release of Table, a crucial tool for improving data formatting in Zoho Sheet. More than a formatting tool,
        • Introducing Data Bars: Graphically represent changes in data within the cells

          Conditional formatting has helped millions of spreadsheet users analyze and highlight their data more efficiently. In addition to the classic rules, color scales, and icon sets available in Zoho Sheet, you can now apply Data Bars, a convenient method

        Zoho CRM Plus Resources

          Zoho Books Resources


            Zoho Subscriptions Resources

              Zoho Projects Resources


                Zoho Sprints Resources


                  Zoho Orchestly Resources


                    Zoho Creator Resources


                      Zoho WorkDrive Resources



                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

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

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • How to merge data from Zoho CRM to Zoho Sheet

                                  Hello! A few months ago, I made a Zoho sheet with the ability to bring in data from Zoho CRM. It worked by adding the email of a Contact to the sheet, and then it would fill in the rest of the information in the row with information that was stored in
                                • Newsletter Templates Are Not Mobile Responsive

                                  Hi, I've already submitted this request to ZOHO once this morning, but for some reason your system logged me out, wouldn't accept my username/password login, and isn't showing any evidence that I've submitted this issue. So here we go again... I am under the impression that your newsletter templates are supposed to be mobile optimised: https://www.zoho.com/campaigns/blog/responsive-email-marketing.html This is clearly not the case, as the last 2 newsletters I've created in Campaigns look perfect
                                • Automatically associate contact with product

                                  Hello, I created a Real State scenario at CRM where I have property owners that are contacts, and properties that are products. After creating a contact and a product, I associated them. My Desk is integrated with my CRM, and it automatically creates
                                • Identify and clean hard bounce lists in Automation 2.0

                                  Hello. 1. I want to know how I can identify hard bounces in the lists I created to clean them before sending an email, given that the bounce rate has increased and it is necessary to clean the lists. 2. How can I exclude hard bounces and invalid emails
                                • Round-Robin with Load Based Assignment, can you limit which Status are considered?

                                  Hello, We are currently using Round-Robin with Load Base Assignment. Is there a way to exclude tickets of a certain Status from being considered by the Round-Robin Assignment rules? For example... I have the following statuses. Escalation Review (meaning
                                • Recipient accidentally added to ticket?

                                  One of my users copied email text from a client into the description of a new ticket. The ticket was intended to be for internal use only, so imagine our surprise when he received an email notification, replied, and his reply was added to the ticket!
                                • How to link to/displaya png stored in workdrive in a Creator HTML snippet?

                                  How to link to/display png stored in workdrive in a Creator HTML snippet? I've tried it as a plain external link and as an iframe. The iframe works but is kinda slow...and I'd prefer to be able to do finer-grained positioning but referencing the png as
                                • Limit excceding issue in zoho creator

                                  I am transferring data from Zoho Books to Zoho Creator using a Deluge script. However, I am frequently encountering a "limit exceeding error," which seems to be related to the Deluge statements limit. I reached out to Zoho Support, and they informed me
                                • Zoho Creator Integration with QuickBooks: A Step-by-Step Guide

                                  Introduction: Integrating Zoho Creator with QuickBooks allows you to sync your business data between the two platforms, providing a seamless experience for managing accounting, invoicing, and financial data. This integration helps automate workflows and
                                • Alter a system defined field from a 'single line' into a picklist

                                  Hello,  I am looking to switch the STATE field, which is a Zoho defined field from a 'single line' into a picklist. Can you advise how to change this?
                                • Zoho Advanced Session audit is hogging RAM

                                  Hi! I've been noticing an issue with Zoho Unattended where it occasionally takes up a lot of the RAM on our computers. It's causing issues for me on PCs that are alreayd low on RAM. Does Advanced Audit have to be disabled for our entire organization to
                                • Issue with Blueprints in Zoho Desk

                                  Hello, I’m experiencing an issue with Blueprints in Zoho Desk. I have some Blueprints that haven't been modified since July 28, 2023, but they suddenly started having issues. In some cases, it’s not possible to move to the next stage; when clicking the
                                • WHMCS Integration

                                  Hello, I was hoping that someone might be able to help me with this one. We use Zoho Desk for support tickets for a couple of companies. One of them uses WHMCS for client billing, payments etc. One area of WHMCS that we do not wish to use is the in-built
                                • Feature Request: Mass update selected Contacts to Accounts

                                  I can't believe this isn't an ability already. It's a quick fix that would save hours of manual entry time. This looks like it had been requested 3-4 years ago with no answers from staff! Please add all contact fields into the "mass update" menu. You can select multiple contacts in list view, but somehow you can't mass update them to all be associated with an account?  And you can't pick a multi-select box to mass update either? The field names already exist in the contact details. Why can't I click
                                • INVALID_OAUTHTOKEN using Self Client Access Token (Android)

                                  Hi, I using the Zoho Android Demo app to try to evaluate Zoho Assist. https://github.com/zoho/Assist-Customer-Android-SDK-Demo I am successfully able to get an access token by POSTing the generated code from Self Client via POSTMAN. scope = ZohoAssist.sessionapi.ALL
                                • Rollup summary for custom module

                                  Rollup summary feature was introduced almost a year ago: https://help.zoho.com/portal/en/community/topic/introducing-rollup-summary-in-zoho-crm-public-early-access-2023 It does not support custom modules tough and this post aims to track such feature
                                • Error 403: Forbidden When Updating Email Signature via API

                                  Hi Zoho Desk team, First, congratulations again on the excellent Zoho API. But, I’m encountering an issue while attempting to update an email signature via the API. Whenever I make a request to update the signature, the response returns an HTTP 403 Forbidden
                                • Reorder Point trigger for custom action

                                  Is there a way to trigger workflows when stock on hand reaches an item's Reorder Point? Requirement: When stock on hand for an item reaches the reorder point, a Purchase Order is created with the concerned item in it, and its quantity is based on a custom
                                • Introducing a Refreshed Design To Enhance Your Zoho Books Experience

                                  Hello users, We are excited to bring a refreshed design along with enhancements to the user interface in Zoho Books. You might have already noticed the new color themes with redesigned icons in your Zoho Books organization. Here’s everything you’d want
                                • HOW CAN I ADD A PDF OR ANY FILE DOCUMENTO ON A CELL FROM MI C: DRIVE PC WITHOUT A WEB STORAGE LINK

                                  I want to add a PDF file reports on a ZohoSheet Cell but i dont know how. I can add images but not files. Can you help me? Thanks a lot.
                                • Issue with Zoho Books /Zoho Inventory Support Team

                                  Oh my goss! This ticket just got closed without a solution/response?! (attached screenshot) That is so pathetic. I thought I could keep impartially all tickets tracked in your help website. Do I need to track issues raised to zoho support team in a separate
                                • Where can I find my documents

                                  I am evaluating solutions to store text documents. I once created one text document on zoho and worked on it. I came back to zoho a few weeks later. Impossible to find it again. Is there a web page containing my documents or my folders? How can I retrieve
                                • way to change the interface language (e.g. to English) in the whole Zoho One ecosystem at once

                                  Hi everyone. I had a need to create a new Zoho One account for a new company. However, since I did it from Germany, I have defaulted to German language in Zoho One interface (in all apps). Can you please tell me if there is a way to change the interface
                                • Create custom rollup summary fields in Zoho CRM

                                  Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were
                                • Holidays and celebrations: Unveiling SalesIQ's seasonal theme!

                                  The holiday season is upon us, and we are feeling all the more merrier at SalesIQ while we unveil this seasonal update. Get ready to sprinkle some holiday magic onto your websites with SalesIQ's new seasonal theme. This new festive theme will provide
                                • Allocate emails to user in a shared mailbox

                                  Hi, This might be obvious, but I cannot find the answer. I have 3 shared mailboxes so any team member can see the emails. Is there a way of allocating a specific email to a user so that it is their responsibility to deal with it? Thanks in advance.
                                • Function not working if more then 1 Record is selected

                                  Hi there! I have a function like this: string button.PCS_TempDruck_Rechnungen(string Modul, int ID) { //Do some stuff here return "finish" } I linked this function to a button in the List View and Mass/Multi-Action of the Quote Module. Arguments: Module
                                • Incoming call logging in Bigin

                                  Request support on how can we log calls on bigin which are incoming. This is one of the very critical requirements for us
                                • How to link Custom Fields in Ticket view

                                  Hi team, I have created 2 custom fields in our Accounts Module would like them to show in our ticket information. We don't have Enterprise so I cannot do it via a workflow, but I know you can do lookup fields to link modules. How would I go about making
                                • Totals on Pivot Table

                                  Is there a way to change the way the subtotal calculates? In this example I have a formula to give me the average monthly attendance ....but I want the grand total of the month to be the sum of all the average attendances...any ideas? Thank you!@
                                • Introducing Zia LLM: Zoho’s in-house Generative AI solution for CRM's AI capabilities

                                  Hello everyone, We're excited to announce the launch of our in-house Large Language Model (LLM) by Zia to power our AI offerings. What is LLM? LLM stands for Large Language Model, a powerful AI technology that processes and generates human-like text based
                                • Assistance with Setting Default Values for Zoho Chat Custom Fields

                                  I am currently using the Zoho Chat JavaScript API to successfully add custom fields to the chat interface. While the implementation of these fields has been smooth, I am now looking to set default values for these custom fields. However, I couldn't find
                                • Unable to delete Junk Lead and Not Qualified from the Lead Status field

                                  Are Junk Lead and Not Qualified default fields or something that cannot be deleted? I have gone into the Leads module and made sure there are no records using these values. Other values have a minus sign that allows me to remove them, but these two fields do not have that option.
                                • Modules are continuously loading

                                  Hi! We are not able to open the task modules, it keeps continuously loading
                                • Customer Happiness not clickable when using API

                                  Is there a way to automatically add the Customer Feedback links when generating email drafts via the API? Currently, the feedback links are only added when generating an email draft using the UI. I tried using the endpoint described in https://desk.zoho.com/DeskAPIDocument#CustomerFeedback#CustomerFeedback_Getthecustomerfeedbackplaceholderlink
                                • Emmanuel Katto : Zoho Meetings Outlook Plugin Authentication Issue - Help Needed

                                  Hi everyone, I'm Emmanuel Katto, We’ve been facing an issue with the Zoho Meetings Outlook plugin for the last couple of weeks. When we try to sign in via the plugin, it redirects to the authentication page, and after successfully authenticating, it shows
                                • Transitioning FESCO Bill Project to Zoho Sheets and Integration Options

                                  Hello Zoho Support, I'm considering transitioning my FESCO bill project from Google Sheets to Zoho Sheets and wanted to know if there are integration options to seamlessly migrate our existing work. You can view our platform here, any guidance would be
                                • Email Alerts for New Audit Log Entries in Zoho Desk

                                  Dear Zoho Desk Team, The Audit Log feature in Zoho Desk is a fantastic tool for tracking changes and ensuring transparency in the helpdesk. However, to make this tool even more effective, I’d like to request an enhancement. Currently, there is no option
                                • Zoho Desk Validation Rule Using Custom Function

                                  Hi all, I tried to find the way to validate fields using custom function just like in Zoho CRM but to no avail. Is there a way to do this?
                                • Free user licenses across all Portal user types

                                  Greetings everyone, We're here with some exciting and extensive changes to the availability of free user licenses in CRM Portals. This update provides users with access to all Portal user types for free to help them diversify their user licenses and explore
                                • Next Page