Index is a table calculation. As such it is applies to the data that is returned to the particular view it is being used in. It is calculated along the dimensions that are in that particular view and will return different results depending on what the 'compute using' is set to. In other words it is completely dependent on the worksheet it is used in. So would wouldn't make any sense to apply it to several different worksheets.
Workarounds? Describe what you're trying to do and post a packaged workbook with some sample data and we can let you know.
Thank you for your response.
My Dashboard has two views: Tree Map & Detail Customer information
My data source is Oracle Essbase
Goal: Two refresh each report showing the Top n Customers.
I am trying this since I am having a query performance issue when using the standard filter dimension by TOP option. (I have opened a ticket with Tableau on this describing why the query is running so slow).
I will work on getting a sample workbook ready.
example.twbx.zip 57.2 KB
1 of 1 people found this helpful
See the attached, I used a parameter and a calculated field using [Rank]<=[Rank Parameter] instead of the Rank value directly.
While Shawn's point is correct that the *values* of a table calculation are entirely dependent on the pills in the view and their settings, there are cases where we have measures that return some set of values out of different worksheets that we want to filter across. Tableau already lets us do this, we can set up a continuous measure like SUM(Sales) and filter that across worksheets that have entirely different levels of detail (like country and item in this view from superstore sales):
There are definitely challenges with returning a valid range of values for the domain of a measure, and I think it's possible for them to be worked out, which is why I created the following Ideas:
Hope this helps!
Thank you very much, this works perfectly and performs very quickly.