This content has been marked as final. Show 2 replies
We have a Pivot table like -
We have another similar table, which looks like -
Now in first image, Product is a Dimension whereas, M1, M2, M3 are calculated measures.
In second table, we have Measure M1, M2, M3 as Inline load, and using pick match function we are calculating Avg, Sum and Diff.
Any idea regarding, how we can combine both the tables.