Calculate Years based on a base year

[tmumaw]

I have this pivot table where I want to calculate percent of increase or decrease based on the first year (2013).   Any ideas?

thanks

[aarkay29]

try this

(

sum(OrganicClients)-Sum({1<FISYR={$(=Min({1}FISYR))}>}OrganicClients) 

)

/

Sum({1<FISYR={$(=Min({1}FISYR))}>}OrganicClients) 

[sunny_talwar]

May be this

Sum(Measure)/Sum(TOTAL <GM> {<FISYR = {"$(=Min(FISYR))"}>} Measure) - 1