Need to create two tables in Qliksense: one with positive sales growth and other with negative sales growth like the one in the below picture. How do I separately compute the 'Grand total' in each case i.e, for positive and negative?
% of Total Sales growth = (Sales growth for a package/Grand total) *100
Please help in computing grand total so that i can be able to compute the '% of total sales growth'.
In the current version, under appearance, 'Totals' fx is calculating the total of positive and negative. I need to segregate both the totals. Please help.