1) Create a calculated field as the below image.
2) Place the above calculated field on the view.
3) Now view has been broken down into Current Quarter, Previous Quarter,Previous Year Current Quarter ans Null.
4) Drag the Calculated field onto filters shelf then deselect the "Null".
5) Now reports is showing only "Current Quarter, Previous Quarter,Previous Year Current Quarter".
6) If you want to hide Current Quarter, Previous Quarter,Previous Year Current Quarter names on the view, then right click on Calculated field on the work area, then select "Show Header".
No comments :
Post a Comment