2 of 2 people found this helpful
The easiest way to synchronize the two views on the dashboard is to make sure that the headers & labeling are the same on each, in this view I just right-clicked on the Customer Name label and turned off "Hide field name labels for rows":
However this kind of view has a problem because as soon as the # of customers gets to be more than fit into a single window we end up with scroll bars for each.
An alternative is to restructure the data. I duplicated the data source, used Tableau's pivot feature to make Sales, Profit, and Order Quantity all part of the pivoted data so now there's a row for each measure with a Pivot field names dimension, wrote a few simple SUM(IF... style calculations, and built this single worksheet view:
Notice that Measure Names isn't being used here, instead I'm using the actual Pivot field names dimension which has all the functionality we might want Measure Names to have.
v9.3 workbook is attached, let me know if you have any questions!
Thank you for your two solutions. In my particular case I can't go with the first one because The viz user could select thousands of dimension members (although that wouldn't be too informative for the structure of this viz ) - but selecting the top 50 would bring out the scroll bars and things could quickly get out of sync as you pointed out.
The second solution is brilliant and is certainly a viable workaround for not being able to use Measure Names in an IF statement! In my case, I haven't figured out a way to make this workable... I'm using a horizon chart with 10 layers and the layer size is defined dynamically by a parameter. For the time being, I'm going with a different approach - but I know your suggestions will come in handy at some point.
Thank you for your solutions!!