Creating a Date Range Filter That Automatically Updates Step 1: Create Start and End Date Parameters Right-click in the Data window and then select Create Parameter. In the Create Parameter dialog box, do the following, and then click OK: Name the parameter. In the example workbook, the parameter is named Start date. For Data Type, select Date. For Allowable values, select All. Right-click the parameter and then select Show Parameter Control. Repeat steps 1-3 to create an End date parameter. Step 2: Create a Parameter to Control a Filter Right-click in the Data window and then select Create Parameter. In the Create Parameter dialog box, do the following, and then click OK: Name the parameter. In the example workbook, the parameter is named Filter ON/OFF. For Data Type, select String. For Allowable values, select List. In List of values, add ON and OFF. Right-click the parameter and then select Show Parameter Control. Step 3: Create a Calculated Field to Use as a Filter Select Analysis > Create Calculated Field. In the Calculated Field dialog box that opens, do the following and then click OK: Name the calculated field. In the example workbook, the calculated field is named Filtered date. In the formula field, create a calculated field similar to the following: IF [Filter ON/OFF]="OFF" THEN [date] ELSEIF [date]<[End date] AND [date]>[Start date] THEN [date] END Drag the newly created calculated field from the Dimensions pane to the Filter shelf. In the Filter dialog box that opens, select Months, and then click Next. Select Exclude and Null, and then click OK. Step 4: Create the View Drag Filtered date to Columns. Drag Filtered date to Columns again, right-click Filtered date on Columns, and then select Month. Drag amount to Rows. Drag type to Color. For Marks, select Bar. Thanks PrepaidCardStatus
.png "Former Employee"){kind=icon}
