Dynamic matrix table with change column at the end of table

[edmundinho]

Hi there,

Is it possible to add change column at the end of dynamic matrix table without interim columns as shown in my example? I understand it's not excel but maybe there are any ways to remove these unnecessary columns? I used measure to calculate change in profit betwen oldest chosen date and newst chosen date. But when I use that measure I get lot of unnecessary stuff in the table.

[edmundinho]

Hello,

My expectation is when user choses more than two or fewer values is to calculate difference between the oldest and the newest values.

[lbendlin]

Yes, it is possible to rededicate the Column and Row totals to run a different calculation.

What is your expectation on the Profit change calculation when the report user chooses more than two of fewer than two values? Change from what to what?