Hello all!
I have searched everywhere to find the solution but no luck. I would like to show different sheets in tooltips for different columns (measure) in one table. In my attached demo table, I want to show 2014 details for 2014 column and 2015 detail for 2015 column, but seems no easy way to do that. Once I insert a sheet in tooltips, it will show uniformly across the all the column. I have come across some post saying use different Axis, but couldn't figure out how. Can you please show me how to do it? Much appreciated!
Hi @Tableauuuu uuuu
Just curious, why would you have the "Profit" split by Years as different measures? We can use the YEAR(Order Date) itself to split the SUM(Profit) This way the view will be simpler.
Check the attached workbook and have a look at the Red coloured sheets. Let me know if this helps
