Matrix Visual - Formatting and Inter-Visual Value referencing

[TheTee]

Hello Community,

I need to create a table with a two-column heirarchy. The top heirarchy is an enumeration of years, the bottom heirarchy is [sum],[% progress comparison to last year],[difference to last year]. For each year these three columns are to be listed.

So, in essance, im slicing up the value data in context of 3 aspects over [n]years. As far as I know, its impossible to directly compare/reference data filters within the visuals themselves ... and thats precisely what I need, seeing the year-comparisons.

The only way I can see to do this is to "hard code" the value columns by hand, ignoring the Columns mechanic and simply throw these directly in the values field - with all the problems resulting from that.

Is there a way to "generically" do this with measures or do I need to "hard-code"?

[TheTee]

Allow me to give more context:

In that visual, Im basically grouping my sales volume info by years (top level columns) and, using measures, im doing my calculations on these (bottom level columns). Specifically, I need a way to manipulate the filter context of the year in which im grouped, subtract that value by one to get the value from the last year, then calculate further with it.

The question is: can I manipulate the filter in that way? If so, how?