Trying to get previous

[rcorcoran]

HI

I am trying to put this in the script to have a field showing outturn as the previous year to the year selected.  Can anyone help??

Thanks

if(MetricKey =10 and ReferredMM=12 and ReferredYYYY= (ReferredYYYY)-1,MetricKey) as Outturn

[tresesco]

This is not enough information to help you. However, I guess you if you are thinking of joining the new field to the existing table, you have to basically use the following logic:

Table1:

Load

          Year,

          Data

From <>;

Join

Load

          Year-1 as Year

           Data as PreData

Resident Table1;  

[rcorcoran]

Ok

I am sorry but I have a table as follows

I want the table to show a field before January only that has the figure from the December of the previous year in it as an out turn figure.  I have tried to put it in expressions but it shows up as a column beside each month with the figures at the end in for december but I just want 1 column with the december figure in it before January.

Thanks

ServiceProvider	Month	Jan	Feb	Mar	Apr	May	June	July	Aug	Sept	Oct	Nov	Dec
Adelaide & Meath Hospital Inc NCH (HIPE)		28.6	31.6	27.4	21.4	16.0	16.9	15.9	18.8	20.3	15.1	16.9	13.0
Bantry General Hospital		12.6	14.3	13.4	21.9	83.3	9.5	15.4	12.3	12.8	13.5	14.9	35.1
Beaumont Hospital		41.2	37.3	34.2	27.8	23.3	25.2	23.5	22.4	19.4	18.1	20.3	21.7
Cappagh National Orthopaedic Hospital		7.0	37.5	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Cavan General Hospital		15.0	15.4	15.8	10.1	10.6	10.7	11.7	10.9	10.2	11.0	10.3	10.6
Children's University Hospital Temple Street		9.3	5.4	7.6	6.1	3.5	3.9	2.9	3.0	4.5	4.0	4.3	4.7

[tresesco]

So you are using a pivot table. To achieve the same, a bit of script work would be required. try to post your sample app with sample data as INLINE. That would be fastest way to be helped.