If I create my reports in 8.3 can I open in 9.0.0 version? for some reason not able to open the reports..Fix

1. Identify the Workbook which contains the Old connection 2. Identify the Data Source which needs to be edited within the Workbook 3. Save the Data Source to an .XML file (.twbs) on a local file system 4. Open the .twbs file in a Notepad or Notepad++ 5. Create an Excel spreadsheet with the original table names, column names and the corresponding new table and column names 6. Need to search the file for the “Old tables” names listed in the .twbs a. Note down the line numbers or save the output in to an excel or ascii file b. Edit the old columns names also in the entire file c. Edit the join criteria with the right join condition (inner as opposed to full outer) 7. Upon completion of the changes, search for any old values if any 8. Open the .twbs in tableau desktop and ensure that there are no errors 9. Now open the workbook and replace the old datasource with new one.

Top 10 and Bottom 10 values by Sales

1) First you create a set for top 10 Products by Right click on a product field-> then create a set -> then select "Top" ->  then define "10", choose "Sales"  with sum.

2) Create second set  for create Bottom 10 Products by right click on a product field -> create a set -> then select bottom -> then define 10, choose sales with sum

3)  now combine the first and second set, by clicking on any one of the sets and -> selecct combine set -> select all values 

4) First drag the sales in to rows shelf, and then Products in to columns shelf.

5) Now drag the combine set in to the filter shelf... now your view will have only top 10 and bottom 10 values by sales.