Part of the way there but not quite the full answer I'm afraid.
What I want to achieve is this result but not in a viz. I want to use LOD or something similar to define the dimensions of my calculation but then sum over the time dimension, variably for MAT, MQT etc., so that I get a series of values for each month in my data table for each row of the dimensions so that when I select 3 isolated months in my table I can pull the relevant value, usually MAT, to perfrom further calculations without the necessity of having all the months in view, i.e. I want to retrieve:
Product Date Measure(MAT) Further calculations
prod a Jan 2016 1256.00 e.g. YOY difference
prod a Jan 2017 1368.00 or % Change etc.
prod a Jan 2018 1686.00
I only want to retrieve the 3 values not 36 months of monthly values to calulate just the 3 I want to use.
I also want to use the same calculation to be able to parameterise my measure selection so users can swap between, say, Month and MQT.