Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want this type of pivot table in qlik view
here year wise F and M sum is total 100% but when I did it I got correct result if I show on 1 year info as I select more then 1 yr then total % divided into two years.
i.e. YTD 11-12 and YTD 12-13 total % sum is 100% irrespect to each YTD.
can you provide data source
I have posted it ,But I dont know where,
Could I drop mail of it,
here how I attach file
click reply and then click use advanced editor then attach the files
I have attached,
Here If I choose single month at a time, I got correct result,
But If I choose jan and feb both than % distribute between two months.. so on..
Thanks for help
do you have data source in excel
no, it is in sql