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.
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Subashree Ramamurthy
yc
Monisha P R
Joe Achakji
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 FormatFormat 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
New to Zoho TeamInbox?
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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Batch Tracking Enhancements In Zoho Inventory
Hello users, We’re excited to announce that we’ve taken batch tracking to a whole new level in Zoho Inventory! We’ve made it more accessible and easier to use than ever. Here’s a quick look at the improvements: 1) A New Way To Create or Modify Batcheshow to sync shopify orders to zoho inventory instantaneously?
hi, Is it possible to sync shopify orders to zoho inventory sales orders instantaneously using zoho flow? if so can anyone give me a step by step guide as im not too tech savvy. currently i have set up sync at 15 min intervals but thats too long for me.Inventory Valuation Method Feature
Zoho added another feature so called Inventory Valuation Method of each Item. This is actually good to see and it will benefit us so much but I have a question on this. For Existing Items that already have transactions, Zoho made it a default and assumedConnecteur Zoho vers Dolibarr
Bonjour, Contexte : * j'utilise Crm et Campaign pour gérer ma prospection et mon pipeline. * nous venons de prendre une franchise de commercialisation de services qui nous oblige à utiliser leur Erp développé Dolibarr Besoin : Continuer à utiliser CrmZoho CRM Kiosk issues
Firstly this is for a system on the AU servers if that makes a difference. Issues are as follows (For Kiosk): 1. Re-ordering fields in the screen builder is broken. The fields seem to be re-ordering themselves, unless you order everything by moving theHow to Send Interview Schedule on Email by Deluge
Hi Zoho Users. I am vishal kumar and working as a Zoho Developer. some of the User is faces the Problem about workflow for sending the invitation to candidate interview link. like that I can help you. Step1:- Get attachment of interview when you createGlobal "Search" in FSM
I'm missing the global Search function like in CRM. This should save us a lot of time. We don't now upfront if the customer is a Contact or a Company. So now we have to guess in what module to start a search/filter. Also looking up an address, phone number,Stopping Scheduled Actions From Workflows
Any idea who this can be done? Is it done automatically? I can't find anything in Zoho explaining.Bar Charts in Zoho CRM
Hello, We are using the Analytics section in Zoho CRM (not Zoho Analytics). We created two bar charts using a workaround with LinkMatch: each time we send a message to a lead/contact on LinkedIn (not on Sales Navigator but the “normal” LinkedIn”), a newMulti-currency in Zoho CRM Forecast and Reports
As a company we have branches in 4 different countries with as many different currencies. Our Sales Teams would like to work with their local currency as much as possible. The Forecast module using only 1 currency is practically usable only by the salesZoho CRM - Create Report out of a Graph
Hello, I created two graphs that measure the weekly sales activities on the basis of messages send on LinkedIn (we are using a third party tool that saves all LinkedIn messages automatically as a note). The graphs and the corresponding settings look likeDirectly Edit, Filter, and Sort Subforms on the Details Page
Hello everyone, As you know, subforms allow you to associate multiple line items with a single record, greatly enhancing your data organization. For example, a sales order subform neatly lists all products, their quantities, amounts, and other relevantCreate 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 werePOS Integration with Inventory
Hello! I'm looking for a good option for Point of Sale that integrates with ZOHO Books, including INVENTORY. Or maybe a different, easier way of doing things. Currently I am using Square for POS. While I was able to integrate the transactions (cashEdit / Modify system generated emails
Hi, System generated emails are great and are very helpful (tasks, etc). Why not allow us the ability to edit them? add/remove/reorder/reposition fields? I'm referring to emails sent from systemgenerated@zohocrm.com BTW - There's an old thread about thisUnattended Installer failure Error 1001
I found by renaming the PC I was installing and trying again it work. This has happened several times when cloning and installing many pcs and forgetting to change the computer name before installing Zoho assist. Somehow I think the computer name is gettingIndividual Ticket Color
It would be great if we can assign color for tickets like this: or this : it will help to find tickets Thanks RegardsAdd Action to Remove/Delete Users in Jira
Hi, I hope you’re doing well. I noticed that Zoho Flow currently allows the creation of users in Jira, which is great. However, there is no option to remove or delete users from Jira through Zoho Flow. This limitation can be challenging when managingIs the a way to show the actual Zoho Books Invoice in Zoho Crm Deal ?
Im currently using the following code to create deals and tasks based off a new quote in zoho books, the problem is the quote is created under Accounts in CRM in the Zoho FInance Module, so when the deal is created it does state the amount of the quoteZoho Finance in CRM Missing Key Elements
When creating an estimate through Books for a customer to accept, when you add a line item there is the dropdown to "Add New Item". Which opens up a panel to link it to Inventory (if needed), and affects Purchase Orders being received, the items beingSending Estimtes to approval from CRM Finance module
Hi, This is the second time I'm facing this user experience problem. I hope you might give some insight on how to either do or explain colleagues / clients. A sale person is responsible to create an estimate for a deal from the CRM. However the estimateHow to Iterate a Function in Zoho Desk Workflow with Delay Between Calls?
Hi everyone, I’m working on a function in Zoho Desk that searches for a specific ticket record. If the ticket is not found, I need to retry the search multiple times with a delay between each attempt until the ticket is located or a maximum number ofZoho Kiosk - Products module
I am creating a kiosk to build a new product. The Create Record method does not have the Products module as a choice. What is the procedure to get the Products module into this list?Need Help Validating Requests in Channel Pull & Push Integration
We’re currently working on an integration that utilizes Channel Pull & Push functionality. As part of this, we need to validate incoming requests, but we’re facing some challenges in getting the validation steps to work correctly. Here’s a simplifiedAdd "Merge by Ticket ID" Option on Ticket Screen
Dear Zoho Team, We would like to request a new feature for the ticket interface in Zoho Desk. Specifically, we propose adding a button to the ticket screen that allows users to merge the current ticket with another ticket by directly providing the secondChange lead status via url parameters
Hello, We have a lead generation form on our website and and we received an email when the lead is generated. This email contains a link to the lead in CRM. Does CRM have built-in parameters so that I could have a link in the email that also says junk?Export CSV from published public report
Is there a way to create a perma link to a pull the CSV or other export type for a published report?Editing HTML in Zoho CRM Email Template
I am trying to create a template within the CRM email option, but need to be able to use custom HTML. There does not seem to be a way to do so.Error when trying to categorize bank transactions
I am trying to categorize my bank transactions. It was going fine, I categorized 50 or so transaction and suddenly I started getting an error that reads: "Transactions cannot be matched as the account you are trying to match it to, is different.". I selectHow to send invoices to 2 emails?
Hi! We are sending invoices to the "Customer email" field that is defined Zoho Books and is obtained/synced from a custom email field in Zoho CRM. But in some clientes, the invoices have to be sent to 2 emails and we are wondering how this could be accomplished.What can we do on our end to improve the Answer bot answers?
Hi, I'm using the Answer bot card in the Codeless bot builder. I've input several questions and their answers in the FAQ section to feed the Answer bot. The text is all in French, as this is the language our customers communicate in. I've tried testingGoogle ads and zoho forms thank you page 2025
We have implemented CNAME in zoho forms. Google Ads wants us to run a thank you page, and they require that thank you page be hosted on the main domain and not the sub-domain. Is there a solution to this? Called to support and they had no idea how toError 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 ForbiddenInclude SalesIQ activity when sending Forms data to CRM as a new Lead
Is there a way that when I get a new lead via a zoho form on my website to include the activity in CRM? I have Sales IQ integrated with the form however, most of my leads do not talk to us through the chat fuction but they do fill out a zoho form. IdSubject Line Editing
Good morning How can we change the subject line of an email?Should I Add Leads in Bigin?
ok, first off I'm new here. I just started using Bigin. I'm debating if it's appropriate to enter leads. by leads I mean a list of contacts that I have not yet reached out to...it's a cold calling list. if I enter them I can track them (I understandSurely it's time Inline editing from views
I think the first request I found for in-line editing from grids was approximately 12 years ago - that post was locked because it was suggested Zoho sheetview solved the problem. However, it's now 2024, and in-line editing from grids is just a basic expectation.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[ZohoDesk] Improve Status View with a new editeble kanban view
A kanban view with more information about the ticket and the contact who created the ticket would be valueble. I would like to edit the fields with the ones i like to see at one glance. Like in CRM where you can edit the canvas view, i would like to editZoho Social API for generating draft posts from a third-party app ?
Hello everyone, I hope you are all well. I have a question regarding Zoho Social. I am developing an application that generates social media posts, and I would like to be able to incorporate a feature that allows saving these posts as drafts in Zoho Social.Next Page