Growth Calculation with hierarchy

[harveenkaur]

I want growth for the city sales data and along with growth for the district and state sales to which city belongs. The data must be presented in the format given below in the table.(QVF is also attached along).

Growth Formula=(CurrentYearSales-LastYearSales)/LastYearSales.

City	City Sales Growth	District Sales Growth	State Sales Growth
C1	x%	x%	x%
C2	x%	x%	x%
C3	x%	x%	x%
C4	x%	x%	x%

[sunny_talwar]

Like this?

Expressions

Sum(CurrentYearSales)/Sum(LastYearSales) - 1

Aggr(NODISTINCT Sum(CurrentYearSales), District)/Aggr(NODISTINCT Sum(LastYearSales), District) - 1

Aggr(NODISTINCT Sum(CurrentYearSales), State)/Aggr(NODISTINCT Sum(LastYearSales), State) - 1

[harveenkaur]

Yes, it worked. Thank you.

[sunny_talwar]

Awesome