Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table in qliksense and need to add a column of % growth between 2017 and 2018.
if i add it as a measure i get the amount on each Quarter instead of only one time in the end.
This i what i need:
2017 | SUM | 2018 | SUM | Growth | ||||||
Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | ||||
50.00 | 100.00 | 200.00 | 150.00 | 80.00 | 54.00 | 89.00 | 91.00 | 314.00 | 12% |
Thanks for any help
Cheers,
Hi Limor,
I had a situation like this before,
we tried to add the difference ,
in your case it is growth...
i think i pivot we cannot add it as measure , which will reflects in to two years.
instead of Pivot table we managed with straight table as a seperate column at the end ..
might be helpful..
Thanks
PM
Hi,
Thanks Praveen,
but How did you had add the columns year and quarter in a straight table?
Regards,
Hi Limor,
i understand there will be redundent data,
well in Our case it is a master Detail sheet , we had added year and quarter as dimensions and measures asusual and growth percentage as measure .
might be helpful......
Thanks
PM.