Adding Previous Year/Month's Sales to data table as a calculated column

[Gary Medford]

I am trying to add a column to a data table to add the previous year/month's actual sales. I have attached a small data table to illustrate what I would like to create. The column in yellow is what I am lookng to create.

[Sean Riley]

You need to use the OVER function to refer to other rows in your calculated columns.

 

https://docs.tibco.com/pub/spotfire/6.5.0/doc/html/ncfe/ncfe_over_functi...

https://docs.tibco.com/pub/spotfire/6.5.2/doc/html/ncfe/ncfe_over_in_cus...

 

This expression gives you the desired result based on your example:

 

Min([Actual]) OVER Intersect([G/L ACCOUNT NUMBER],Previous([Yr Mo Int]))

[venkata gopi]

this is very intresting andall what im looking for, could you help me to get the previous sales on my all columns in a data table rather than just one column which you did like above.

i need this in a calculated column.