Please help me to solve this problem

[#1]

Hello All,

Could someone please help me to solve this issue.

I have mentioned it clearly in word document and attached a sample source data in excel. Please have a look at the attachments.

I want to create a pivot table

i)now I want to count the date(as an expression) for the financial year i.e. Apr 2012- Mar 2013 under which all the 12 months should be displayed

ii) in the next column for financial year Apr 2013- Mar 2014 but under this I want to display only may2013 and aug 2013.

Thaks in Advance

[MK_QSL]

Provide 3rd file with your expected output in excel ! Your description is not giving accurate information to proceed further.

[qlikmsg4u]

Please give us the expected output