data in staright table

[mshailaja]

Hi  i have

Sample:
Load * inline [
no,type, opendate,group,description
In2,IN,3-07-2016,manager,sit touat

PR2,PR,23-07-2016,admin,uat to prod
IN3,IN,8-07-2016,manager,sit touat
PR3,PR,13-07-2016,admin,uat to prod
];

i need the data in staright table for INs(incidents) and PRs(problems) for the month of june( i need in master calender with date as open date Here)

can anyone please  help me

[vinieme12]

Hi,

Please see attached QVW