hi pls ignore just got it sorted by matrix table and remove the code of pivot table and using ssrs function for the pivot part. thanks all