Saturday 14 December 2013

Organizing Sheets

::Organizing Sheets:-::
There are three ways to navigate and view the sheets in a workbook: 
1)Tabs at the bottom of the workbook
2)Filmstrip
3)Sheet sorter. 

1)Sheet Tabs:-

  • Each sheet, whether worksheet or dashboard, is represented as a tab along the bottom of the workbook. 
  • Dashboards are indicated with a Dashboard icon next to the sheet name. Simply select the tab for the sheet you want to open.








  • In the bottom right corner of the application window, there are several controls that you can use to advance through each sheet or quickly jump to the first or last sheet in the workbook. 
  • These controls are only available when there are too many sheet tabs to show across the bottom of the application window. You can also navigate between sheets using the Window menu or move through the multiple worksheets by pressing Ctrl + F6 on your keyboard




  • To make it easier to identify and group sheets, you can assign each sheet tab a color. Rightclick the tab and select Color. You can select from seven different colors. Selecting None resets the color back to the default.



2)FILMSTRIP:-


  • Similar to the sheet tabs, the filmstrip displays along the bottom of the workbook. However,instead of sheet names, the filmstrip shows a thumbnail image of each sheet. 
  • The filmstrip is useful when you are using Tableau to present your analysis and works well when you are working in Presentation mode



3.Sheet Sorter:-

  • The sheet sorter shows all sheets in a workbook as thumbnail images on a single page and is similar to the slide sorter in Microsoft Power Point. 
  • The sheet sorter is useful when you have a large number of sheets in a workbook. 
  • Open the sheet sorter by clicking the sheet sorter tab in the upper right corner of the workbook.





Thanks Guru's,
Prazval.ks

DAX Time Intelligence Functions

   Thanks Guru's, Prazval.Ks