A footnote is a good location to note what filters have been applied to a dashboard. A user may sometimes forget which filter values s/he selected, so the footnote summarizes this information in a central location, usually at the bottom of a dashboard.
- To create a footnote, you first need to create a new blank worksheet.
- Then create a dummy calculation.
![Dummy Calculation](/media/5616388/footnote-1.png?width=500&height=287.85046728971963)
- Place the dummy calculation onto the Detail pane.
![Detail Pane](/media/5616389/footnote-2.png?width=370&height=376)
- Right click on the square in the view and select Format.
![Format](/media/5616390/footnote-3.png?width=244&height=333)
- Remove the row and column dividers.
![Column and Row Dividers](/media/5616391/footnote-4.png?width=248&height=392)
- Right click on the square again and select Exclude.
![Exclude](/media/5616392/footnote-5.png?width=293&height=402)
- Place the dimensions you are using as filters in your dashboard onto the Filters
![Filters Pane](/media/5616393/footnote-6.png?width=312&height=311)
- Right click on the worksheet title and click Edit Title.
- Click on the Insert drop-down list and the dimensions you just added to your Filters pane should display at the bottom.
![Insert Dimensions](/media/5616383/footnote-7.png?width=478&height=317)
- Select each dimension to add them to the title.
- Make sure to properly label each dimension and add a title as explanation (i.e. Filters Applied).
![Filters Applied](/media/5616384/footnote-8.png?width=462&height=291)
- Click OK.
- The values selected in your main worksheet should display in the title.
![Filters Applied](/media/5616385/footnote-9.png?width=485&height=96)
- Save the worksheet.
- Navigate to your dashboard and locate the new footnote worksheet in your Sheets
![Sheets](/media/5616386/footnote-10.png?width=168&height=315)
- Drag and drop the footnotes onto your dashboard and position it at the bottom.
- Test the filters to make sure they are applied in the footnotes. If not, you may need reapply your filters.
- Click on the filter that isn’t working and click on the More Options Then hover over Apply to Worksheets and click Selected Worksheets.
![Apply to Worksheets](/media/5616387/footnote-11.png?width=498&height=214)
- Locate the footnote worksheet in the list, check it and click OK.
- The filter should then work properly.
Download Dashboard Footnote PDF