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

        • Track Items - Sprints History

          I want to track when items move from "Active Sprint" to "Upcoming Sprint" or "Backlog" in Zoho Sprints. I need to display these items in reports or graphs in Zoho Analytics or Zoho Sprints. How can I do this? We have Deal History in Zoho CRM, but I couldn't
        • Zoho AI Translate – No Support for Hebrew?

          I want to use Zoho AI Translate, but I see that it does not support Hebrew. Since Zoho supports multiple languages, I was hoping this function would also work with Hebrew. Is there any plan to add Hebrew support in the near future? Or is there an alternative
        • Deletion of CRM rows giving error

          Hi, I am exporting data from a module into excel workbook. THis works fine... until...I export the same data 10 minutes later and I get duplicates in my sheet. There is code to "delete" the previous sheet but it is giving errors. The DELETION of records
        • Rename Record Summary PDF in SendMail task

          So I've been tasked with renaming a record summary PDF to be sent as part of a sendmail task. Normally I would offer the manual solution, a user exports the PDF and uploads it to a file upload field, however this is not acceptable to the client in this
        • Creating Layout Rule With Formula Field

          By The Grace Of G-D. Hi, I see that i cannot use Layout Rules to show/hide Formula Fields. Is that something you plan on adding sometime soon?
        • Weekly Tips: Get Work Done Faster with Zia AI

          Every day brings a fresh batch of messages — meeting invites to accept, client feedback to review, colleagues asking for updates, and the constant ping of new notifications. It's exhausting trying to clear your inbox while wondering how you will catch
        • Add clients without needing a client company

          I, like many people, deal directly with individual clients rather than companies. It's really obnoxious to have to add a client company and treat my client, who is an individual person, as a company. Zoho - can you please build in a way to bypass the need for the client to be part of a company? This is a problem in cliq as well - I want to invite my clients to channels in Cliq but needing to create a company is confusing for them and makes them feel as if they don't belong on the app. But that's
        • Setting default From address when replying to request

          At the moment, if I want to reply to a request, the From field has three options, company@zohosupport.com, support@company.zohosupport.com, and support@company.com.  The first two are really internal address that should never be seen by the customer and
        • Can't create task programmatically using deluge

          I have a Date/Time field like this when it is edited, I want to create a task using deluge function. I use the code below to create a task. but unfortunately, the task is never created even I run it using 'execute' button on function editor. what went
        • Ability to add VAT to Retainer Invoices

          Hello, I've had a telephone conversation a month ago with Dinesh on this topic and my request to allow for the addition of VAT on Retainer Invoices.  It's currently not possible to add VAT to Retainer Invoices and it was mutually agreed that there is absolutely no reason why there shouldn't be, especially as TAX LAW makes VAT mandatory on each invoice in Europe!   So basically, what i'm saying is that if you don't allow us to add VAT to Retainer Invoices, than the whole Retainer Invoices becomes
        • Python Code: Calling "Deals" API results in 404 Error.

          Good evening, I wrote a small python code to scrape the data from a selected record and then copy the information I need into another website. We have renamed the "Deals" module to "Opportunities", however the API name remains as "Deals" which is fine.
        • setVisibility() not working for Subform Fields with Client Script

          I am currently working on a Zoho CRM Client Script involving a subform and encountered a limitation that hinders my ability to fully control the visibility of specific fields within subform rows. The setVisibility() method, which works perfectly fine
        • UpdateRecord for contacts doesnt work from rule from another custom module

          I have a function that is triggered by an automatic rule when a record is created or edited in a custom module. The function searches for a record in the Contacts module and saves it in a lookup field of the newly created or updated record. It also updates
        • Office 365 and Zoho CRM

          Does anyone have this synching properly. I configured it and the Zoho Calendar shows up in 365 but nothing comes from 365 into zoho crm. I have enabled the two way. No errors are being generated. If anyone has some insights I would really appreciate
        • How to export Subform Data from a record?

          How can we export the subform data from a record? Currently we can import data, but I found no way to export data from one record I need a simple button to export the current subform data to an excel file, why can we import subform data but cannot export
        • Trident: please make right widget column re-sizable

          I'm really enjoying using Trident and think Zoho is doing a great job developing it and adding features without cluttering the interface. However, the one thing that keeps irritating me in daily use is that the right side widget column is too narrow to
        • Does Client Script work on Zoho CRM Portal?

          Hi ! I create a new module to use at customer portal. But Client Script looks not work. Please help me clarify, thank you!
        • Analytics - Opened versus Clicked?

          Good day, we have just sent out an email campaign vis the mass email option to our contacts lists and i have noticed that more recipients clicked on the email than opened the email. Can that be and can you explain the difference between the 2 statuses
        • Unattended Sessions - Groups and Access

          I would like to see Groups to organize Unattended Computers (what is currently labeled "My Computers") and a way to restrict access to individual users to specific groups.
        • Need help in search with formula culums in reports

          Hello, I do not know where to start with this one : I have a customer report with all that was bought and paid by my customers. It can be many records for one specific customer. Ex. Customer A has 1 record for a purchase of 1000 $, and 2 records of payments
        • 【参加無料】3/19 東京ユーザ交流会 参加登録 受付開始!(新橋開催)

          ユーザーの皆さま、こんにちは。コミュニティチームの藤澤です。 3月19日(水)に東京、新橋でユーザー交流会を開催します! 今年最初のユーザー交流会 東京・新橋では、Zoho Champion の松井さん、鈴田さんが登壇します。 Zoho CRM活用事例のセッション、参加者同士で自社の活用・運用について情報交換ができるグループワークや、CRM / Marketing Automationに関するパネルディスカッションも予定しています。 ーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーーー
        • Genie baked into Truesync

          Shouldn't the functionality of genie be baked into truesync? This is how google drive's desktop app works. It's minor but annoying to have 2 things loaded when it seems it should all just be one app. Just an idea.
        • File attachments adding date and time to name when uploading?

          I have set up a function that uses the mail merger api to get a lead and fill in the details, it is basic but was just using to test will fill in all the details later, It works perfectly fine the only issue i have is that when it uploads the file into
        • Cannot Access Admin Console

          Hello, After I upgrade from free mail to Lite Mail I can't access Admin Console. Always stuck like that. Please help, thank you. Regards, Arman
        • Live webinar: Mastering financial presentations with Zoho Show

          Hey there finance professionals! We know many of you are currently knee-deep in report creation mode to wrap up the fiscal year for your organization. Creating a presentation to communicate essential financial data isn’t simple, with all the calculations,
        • Rejected Accounts still listed for Deal

          Hello guys I have a approval process thats validate the Accounts in CRM The issue is even when a account is rejected you can open a deal with it It's not supposed to appear in the lookup field or the approval process become pointless Can you guys help
        • Optimizing Zoho CRM & Xero Workflow – Advice Neede

          Hi everyone, We’ve been using Zoho for all CRM functions and Xero for all accounting, but the workflow between the two has become difficult to manage. The business does not want to move from Xero, as it's the accountants’ preferred system, but we need
        • Open word documents directly within zoho writer without converting

          There was an article in the help page that said that there would be a feature where zoho writer can directly open MS Word files without the need to convert those files to zoho format. It was said that it would be available by Q1 2023. Here is the article
        • Not receiving email at Outlook

          Hi, I've set up the account and can do everything except receiving email at Outlook. Please find print screen below parameters configured and advise what could went wrong. I can send email from both Webmail and Outlook. I could, however, receive email
        • To unblock , ensure atleast 5% free space of your total mailbox size exists after email deletion.

          Bom dia, Já deletei todos os e-mails , mas ainda não consigo desbloquear o e-mail comercial@hidrotecnicauberlandia.com.br. Já faz dias que deletei, mas ainda não desbloqueia quando sigo os passos de UNLOCKED ME. Por favor me ajudem.
        • Kiosk Page Refresh

          We have a Kiosk running from a button in contacts to update values and also add related lists, which works great, but when the kiosk is finished the page does not refresh to show the changes. Is there a way to force the contact to refresh/update when
        • Zoho does not send invitation email if meeting is created in calendar

          Problem: I create a meeting in calendar and add attendees. After "Save" button it asks me if I want to send email to all ettendees, I click Send. But none emails are sent. I did try that over outlook (connected thru active sync) or in zoho web mail. Nothing
        • Change Background in PDF Template

          Background PDF Hi, I want to ask a question. I want to create a background template with my own image. Above is an example that I made, why does the result not fit the A4 format? Like cut off. I used an A4 Portrait image, is there a size error? can you
        • Spotlight #7 - Automatic Transitions in Blueprint

          Previously, records could not be moved from one state to another without user intervention. With automatic transitions, move records from one state to another automatically, when it elapses its pre-defined time. This Spotlight discusses how automatic
        • Accepted meeting invites not showing on calendar

          I can receive a calendar invite to a meeting, I confirm I can attend and hit accept. I then check my calendar and it doesn't show. 30 seconds later, it does show up but it is delayed leaving the feeling something didn't work correctly. Can this be improved,
        • 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
        • No fue posible enviar el mensaje;Motivo:553 Relaying disallowed. Invalid Domain - admin@laboratoriosantarosa.org

          Hola Renovamos después del tiempo el dominio, y luego de eso se cayó el servicio de correo. Seguimos las indicaciones que se indican en este articulo, sin embargo, hasta el momento solo podemos recibir correos pero no enviar. Hemos actualizado los registros
        • Zoho Error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details

          Hello There, l tried to verify my domain (florindagoreti.com.br) and its shows this error: This Operation has been restricted. Please contact support-as@zohocorp.com for further details. Screenshot Given Below -  please check what went wrong. Thanks
        • Error AS101 when adding new email alias

          Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
        • My IMAP mail suddenly stopped working

          On my iPhone and iPad, IMAP stopped working for my Zoho account with the error "User name or password incorrect" and "Invalid credentials failure" however I was able to access via web with the same credentials. Also stopped working on Apple Mail client.
        • Next Page