Filter the analysis using a column not shown in the analysis In the filters pane, click the a filter for the current Subject Area’ ‘Create Select Columns…’ and browse to and select / Provider ‘More ‘Commissioner plus code’ from the tree and click OK. Leave the operator as equal to/is ‘is in’ and set the value to your CCG. Click OK. Check your work, the CCG shown will vary depending on the CCG selected. Save your analysis as & Naproxen as a % of all NSAIDs’ in ‘Ibuprofen ‘My Folders’ using the Analysis’ or As’ buttons . ‘Save ‘Save Editing a column to show results for a specific set of drugs. Click the cog icon on the first column and select Formula’. ‘Item’ ‘Edit The Column Formula’ pane will be displayed. ‘Edit Ensuring that all the text within the Formula’ box is highlighted, ‘Column select from the task bar at the bottom of the Formula’ pane. ‘Filter’ ‘Column The Filter’ pane will appear. ‘Insert Expand the /Appliance’ folder in the Area’ tree and double ‘Drug ‘Subject click Chemical Substance plus code’. The Filter’ pane will be ‘BNF ‘New displayed. Click the magnifying glass icon to bring up the search window. Ensuring the Case’ option is not selected and the operator is changed to ‘Match ‘Contains’ search for and select the items shown below. Click followed by ‘OK’ ‘OK’ again.
Filter the analysis using a column not shown in the analysis In the filters pane, click the ‘Create a filter for the current Subject Area’ Select ‘More Columns…’ and browse to and select ‘Commissioner / Provider plus code’ from the tree and click OK. Leave the operator as ‘is equal to/is in’ and set the value to your CCG. Click OK. Check your work, the CCG shown will vary depending on the CCG selected. Save your analysis as ‘Ibuprofen & Naproxen as a % of all NSAIDs’ in ‘My Folders’ using the ‘Save Analysis’ or ‘Save As’ buttons . Editing a column to show results for a specific set of drugs. Click the cog icon on the first ‘Item’ column and select ‘Edit Formula’. The ‘Edit Column Formula’ pane will be displayed. Ensuring that all the text within the ‘Column Formula’ box is highlighted, select ‘Filter’ from the task bar at the bottom of the ‘Column Formula’ pane. The ‘Insert Filter’ pane will appear. Expand the ‘Drug /Appliance’ folder in the ‘Subject Area’ tree and double click ‘BNF Chemical Substance plus code’. The ‘New Filter’ pane will be displayed. Click the magnifying glass icon to bring up the search window. Ensuring the ‘Match Case’ option is not selected and the operator is changed to ‘Contains’ search for and select the items shown below. Click ‘OK’ followed by ‘OK’ again.
Training%20Guide%20v1.2.docx