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

[Anonymous]

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

[luismadriz · Accepted solution]

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

[Anonymous]

Hi Luis,

Almost there. See what I got

[luismadriz]

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

Check this for formating: http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/FormattingFunct...

And maybe change the label for Totals to %Growth

Anything else?

[Anonymous]

Thanks a lot

[luismadriz]

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

Cheers,

Luis

[Anonymous]

Thanks again