cancel
Showing results for 
Search instead for 
Did you mean: 

Percent change in a cross tab

nscheaffer
Active Contributor
0 Kudos

How can I calculate the percent change from one year to the next in a cross tab like this?

Here is what I am trying to accomplish show in Excel...

I want this to be dynamic so that it can flex (grow or shrink) as year are added or taken away.

Is this possible?

Thanks,

Noel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Check this

nscheaffer
Active Contributor
0 Kudos

I think I got it.  At first I created two variables...


UV Relative Quantity Change=RelativeValue([Quantity sold];([Year]); -1)

UV Relative Quantity Percent Change=([Quantity sold]-[UV Relative Quantity Change])/[UV Relative Quantity Change]

It also worked to use the Previous() function...


UV Relative Quantity Change=Previous([Quantity sold])

Given the simpler syntax of the Previous() function I feel more comfortable using just one variable...


UV Relative Quantity Percent Change=([Quantity sold]-Previous([Quantity sold]))/Previous([Quantity sold])

Thanks for pointing me in the right direction.

Noel

Answers (0)