6 Replies Latest reply: Dec 7, 2017 1:24 AM by Abbas Alrebh

# How can I add a percentage of sales growth - Pivot table.

Hi everyone,

I want to add a percentage of sales growth from year 1 to year 2 for each category.

It should be something like this:

The formula

% increase = ((Sales year 2 - Sales year 1) ÷ Sales year 1) X 100

• ###### Re: How can I add a percentage of sales growth - Pivot table.

Hi Abbas,

Turn On Totals  for Year and change the sales measure to this:

If(Dimensionality()=1,Sum(Sales),Num((Sum({<Year={2}>}Sales)-Sum({<Year={1}>}Sales))/Sum({<Year={1}>}Sales),'0%'))

I hope this helps,

Cheers,

Luis

• ###### Re: How can I add a percentage of sales growth - Pivot table.

Hi Luis,

Almost there. See what I got

• ###### Re: How can I add a percentage of sales growth - Pivot table.

Good, you now just need to change Sum(Sales) to Num(Sum(Sales),format)

And maybe change the label for Totals to %Growth

Anything else?

• ###### Re: How can I add a percentage of sales growth - Pivot table.

Thanks a lot

• ###### Re: How can I add a percentage of sales growth - Pivot table.

You're welcome, you did a good job explaining and documenting the question,

Cheers,

Luis

• ###### Re: How can I add a percentage of sales growth - Pivot table.

Thanks again