How to create a “sheet selector” that gives the ability to select an individual sheet from the dashboard and replace all sheets with just the sheet selected.
Select create parameter by Right-clicking on data window to the left.
In parameter dialog box assign values as shown below:Data type: StringAllowable values: ListList of values: All, Sheet 1, Sheet 2,...and give it a name
Create a calculated field by Right-clicking on data window to the left)
Give parameter name from step 2 in the Formula text box.
For each sheet in the workbook, drag calculation field created in step 4 into filters shelf and do as follows:
In general tab, select custom value list
type All in the text box and click add item button. type particular sheet name and click add item.
create a dashboard
Right-click on the worksheet and select Parameter --> Select a sheet. You can find a new filter added to your right side and you can select which sheet to show in the dashboard.
If you want to learn more about tableau analytics then you can check our Tableau Training online.
E&ICT MNIT - Data Science and Machine Learning |
IIT Madras - Advance Certification in Data Science and AI |
E&ICT IIT Guwahati - Cloud Computing & DevOps |
E&ICT IIT Guwahati - Cyber Security |
E&ICT IIT Guwahati - Software Engineering & Application Development |
E&ICT IIT Guwahati - Big Data Analytics |
E&ICT IIT Guwahati - Full Stack Web Development |
E&ICT MNIT - AI and Machine Learning |
E&ICT IIT Guwahati - UI UX Design Strategy |
IIT Madras - Data Analytics for Business |
E&ICT IIT Roorkee - Cloud Computing & DevOps |
E&ICT MNIT - Cyber Security & Ethical Hacking |
E&ICT MNIT - Business Analyst & Project Management
Big Data Analytics Courses |
Data Science Courses |
Business Intelligence courses |
Best Salesforce Courses |
Cloud Computing Courses |
Best Digital Marketing Courses |
Programming Courses Online |
Database Certification Courses |
Best Testing Courses |
Project Management Certification Courses |
Best Web Development Certification courses |
Automation Trainings |
Cyber Security Training Courses |
UI UX Course
Data Science Courses |
Best Artificial Certification Intelligence Course |
Machine Learning Training |
Python Course |
DevOps Certification Course |
AWS Training and Certification |
Azure Certification |
AWS DevOps Training |
Azure DevOps Certification Course |
Cyber Security Course |
CEH course |
Big Data Hadoop Certification |
SQL Online Course |
Salesforce Admin Certification |
Online Salesforce Developer Certification |
Selenium Training Online |
Business Analyst Course Online |
Data Analyst Certification course |
Best Microsoft Power BI Certification Course |
Tableau Course Online |
Linux certification Course |
Data Analytics Certification Course |
Digital Marketing Course
MCA Degree Program |
MBA Degree Program |
MBA HR Degree Program |
MBA IT Degree Program |
MBA Finance Degree Program |
MBA General Degree Program |
MSC in Data Science
© COPYRIGHT 2011-2022 INTELLIPAAT.COM. ALL RIGHTS RESERVED.
Download Salary Trends Now !
Learn how professionals like you got up to 100% Salary Hike.