sum in pivot table

[tyagishaila]

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.

[arulsettu]

can you provide data source

[tyagishaila]

I have posted it ,But I dont know where,

Could I drop mail of it,

here how I attach file

[arulsettu]

click reply and then click use advanced editor then attach the files

[tyagishaila]

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

[arulsettu]

do you have data source in excel

[tyagishaila]

no, it is in sql