Hi
How to get YTD in Straight table as an additional measure along with Monthly sales measure in Qliksense
To Detail:
I have Data like
Yearmonth, Volume, Client name, product type
attached has the sample data and I want to calculate YTD and the pct difference along with the last 13 months volume
was able to use set analysis to get the sum for YTD but when I add that in pivot that is getting split by Year month like below
Cname , year month YTD
Jan 2017|Feb 2017|.....|Jan 2018|Feb 2018 Jan 2017|Feb 2017|.....|Jan 2018|Feb 2018
Arun 10 |20.....|30|40 10 |20.....|30|40
Asha 30 |40.....|20|10 30 |40.....|20|10
Can some body help me out to get the YTD and pct difference as Given in the excel
Thanks for all your help ahead
Regards,
mhappiee