Display annual change in rate

[Jazzman]

Hello, I'm trying to make my VA report display the change of a rate from last year to this year in percentage points. The rate is a calculated element that is the sum of one column divided by the absolute frequency of the table. When I try to create a new calculated element that divides the rate by the rate of the parallel period I get the error "nested aggregate expressions are not supported. So what is the correct way of doing this in VA?

[PetriRoine · Accepted solution]

Hello @Jazzman ,

Since nested aggregate expressions are not possible you could possibly work around this using aggregated data sources and then data joins. 

Best regards,

Petri