Let's say I have a table that contains aggregated avg iPhone prices:
|Avg price iPhone 4||Avg price iPhone 5|
Now I would like to compare iPhone 5 avg prices vs iPhone 4. In excel I would simply divide "iPhone 5_UK" by "iPhone 4_UK" and correspondingly "iPhone 5_US" by "iPhone 4_US" but how do I do it in tableau. Let's say creating four hardcoded parameters is not an option and I want to do it automatically.
You can use lookup to get the value
You need to consider how the table is laid out and the corresponding partitioning. Read more about Table Calcs in the help files