The filter windows are used to filter out a limited data set, which you can then analyze and examine.

 

Proceed as follows:

1.Click on the diagram icon on the left in the Extras window to open diagrams. Drag a filter window onto the worksheet.

2.Click on the database icon in the Extras window to open fields.

3.Click on Date in the list to open the field

4.Drag the Year field to the center of the filter window and click the arrow in the right-hand properties window to expand the dimension and change its title to Year.

5.Drag the Quarter field into the filter window and click on the arrow in the properties window to change its title to Quarter.

6.Drag the Month field into the filter window and click on the arrow in the properties window to change its title to Month.

7.Drag the Week field into the filter window and click on the arrow in the properties window to change its title to Week.

8.You can use the drag handles to change the size of the filter window.

9.Right-click on each filter window and select Add to Master Elements

10.Enter the name Period and click Add.

 

You have created a filter window and saved it as a master element. This makes it easy to reuse in other worksheets.

The second filter window only contains a single dimension, Region.

 

Proceed as follows:

1.Click on the diagram icon at the top of the Tools window to open diagrams and drag a filter window onto the worksheet.

2.Click on New dimension, scroll down and select the Region field.

3.You can use the drag handles to change the size of the filter window.

4.Right-click on the filter window and select Add to master items

5.Enter the name Region and click Add

 

The two filter windows are ready.

 

You can adjust the position and size of the visualizations on your worksheet as required.