Discussion board where members can get started with Qlik Sense.
I want to add a percentage of sales growth from year 1 to year 2 for each category.
It should be something like this:
% increase = ((Sales year 2 - Sales year 1) ÷ Sales year 1) X 100
Go to Solution.
Turn On Totals for Year and change the sales measure to this:
I hope this helps,
Almost there. See what I got
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
Thanks a lot
You're welcome, you did a good job explaining and documenting the question,