Calculation

[upaliwije]

Hi Friends

I have apivot table in my QV document which is attached here to. In this data I have 4 regions with 5 years Premium data relating different locations. at Regular Intervals Locations are reshuffled among the regions. I have calculated the growth as shown in the Pivot table. But I want to calculate the growth in a different way. That is I want to calculate the growth for a particular year say 2015 based on the premium of same loaction of year 2014. In other words  realocation of locations to region sholud be disregarded.

Eg:

In the above example a new column should be created to show premium for year 2013 disregarding the region of the loaction. In other words premium should be shown for the location where there is zero values in 2013. Then growth should be calculated based on the premium of new coloumn.

Pls help me to do this

[upaliwije]

For all Years

[sunny_talwar]

May be this

Sum(TOTAL <BCOD, YEAR> Premium)

[upaliwije]

Thanks Sunny

Then all Regions show the same values.

[sunny_talwar]

Try this

Sum(Aggr(Sum(TOTAL <BCOD, YEAR> Premium), RM, BCOD, YEAR))

[upaliwije]

Thanks Sunny for your effort and help. Still I do not get the desired results.

Thanks again

[sunny_talwar]

I am sure you are not, but I don't even understand what is desired

[upaliwije]

Thanks Sunny

For  a single location I have given below the system output and Desired output. It is much thankful if you can guide me to do it thta way.