Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Compare data from different dates in the same table

Hi everyone,

 

I have a data base that updates everyday with new information and I would like to bring the data from the previous day to a new calculated column to be compare with the data from today. Here's a example for better explanation:

 

I have that idea, but maybe there's a better solution for this problem, also I would like to create a matrix with the items in the row section, the 2 dates as columns and other column with the delta of the values. Hope anyone can help, thanks!