Hi all, Not sure if this is possible, have had a look around but not found anything so thought I would ask. We need to calculate population rollover year on year. For example: Year 1 population for 2016 = 100 Year 2 population for 2017 = 95 Rollover = 95/100 ( 5 dropped out) i have set up an index column which is combination of calendar year and program year, this looks like 1701, 1702, 1703, 1801, 1802, 1803. My data table looks like Index - Population 1601 - 100 1602 - 95 1603 - 92 1604 - 80 1701 - 110 1702 - 108 1703 - 101 1704 - 99 etc In our other BI tool I can just create a formula that uses the index column - 101 to reference the previous year then dynamically calculate the ratio. The only approach I can work out in VA is to pre-calculate before import which limits flexibility. Is there a way I could attack this? Any ideas appreciated
... View more