how do you find the maximum number of column value & substrct

RajNadar

Dear All,

Below is pivot table created via chart type in domo

I want subtract latest week - week 1(e.g. week 4 - week 1

next time week 5 (dynamic) - week 1)

next time week 6 (dynamic) - week 1)

e.g 1276 - 319 = 957 result simultaneously other line as well in one column

Regards