Difference of two files issues

[Nagaraj6]

Hello everyone!

I need a help,

I want to difference  of 26 week file - 25 week file .I am using this formula  below:

=Sum(Aggr(Sum(distinct SALES),Reference,FILENAME,MONTH)) .How can change this formula to get output.

[Mark_Little]

Hi,

Could you share a straight table view of the data include the fields used?

I would personally probably look at optimizing the data model and then using Peek or Pervious function to get the value in script. 

[Nagaraj6]

PFA app