If making a single table (without combining on a dashboard) is obligatory,
then such a table could be built, but ... Why? What's the purpose? When in Tableau,
it would be overly complicated, very fragile (every mod is a real pain in the ...) --
and no Totals whatsoever :-) Just asking myself: is it really worth the effort?
Anyway, please find the attached wb.
Hope it would be of some help as a "corner case" for Tableau.
Discrete measures (Blue Pills) have been used for each year
to mimic YEAR([Order Date]) "dimension" columns.
Any number of Measures (Green Pills) could be added
to Measure Names / Measure Values (when necessary).
Help_06092016_YF.twbx 1.2 MB