Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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