I have a top 20 report. Here I have used the index function to show the top 20 accounts since the "top" filter was not working as desired. Now when I am trying to export the report to excel crosstab I am not getting the desired top 20 accounts. How can i rectify this to get the desired top 20?
Go through these links: - http://kb.tableausoftware.com/articles/knowledgebase/finding-top-n-within-category
Hope this may help!
If not you can attach a sample file.