I'm not sure why you need dashboard.
I'm saying you can get same result in single workbook.
The key here is duplicating the data to get last year sales without using parameter.
In second datasource(copied one), duplicate [Order Date]
Rename "Original" [Order Date] as "Order Date Original"
Rename "Original Date(Copy)" as "Order Date"
/// This helps automatic data link.
Link required field,
At least "Order Date" plus other you want to show (In this case, "Category" is added).
Rename 2nd data source's "Sales" as "Sales last year".
Using primary datasource "Order Date", put "Sales" and "Sales last year" from 2nd datasource.
ty ly in dashboard_9.2.twbx 1.2 MB
1 of 1 people found this helpful
Name or rename your dashboard.
Specify who can view and use the dashboard.
(Administrators only) Specify who can edit the dashboard. See Permission to Edit Project Metrics, Reports, and Dashboards.
Select Saved Views if you want to allow users to save their current dashboard filter settings as a named dashboard view. For more information, see Using Saved Views.
Permission to Edit Project Metrics, Reports, and Dashboards:
- With the dashboard displayed, click the Gear icon and then click Permissions.
- Select Only Admins, and then click Set Permissions.
Lock Reports and Metrics:
- Go to the Reports page.
- Select the reports, that you want to change, and then click Permissions.
- In Permission settings, select who can edit the report.
Change Metric Permission Settings
- Go to the Manage page.
- Click Metrics.
- Select the metrics that you want to change, and then click Permissions.
- In Permission settings, select who can edit the metric.
Using Saved Views:
The Saved View feature lets you save frequently-used dashboard filter settings as a named dashboard view. Your Saved Views are available from the Views drop-down menu on the upper right of the dashboard, and your currently selected view is remembered across dashboards, dashboard tabs, and logouts of the Portal.
Enable Saved Views:
- Click Edit > Actions > Settings.
- Select Saved Views, and then click Save.
Save a View:
- Set the dashboard filters to the values that you want to save as a view.
- Click Unsaved View > Save.
- In the Save current view dialog box, select the filter(s) that you want to include in the view.
- Filters set to All and filters with no values selected are excluded from the list.
- When you save a view, filters that you did not select are reset to their default value.
- 4.Enter a name for the view in the Save current view dialog box, and then click Save.
Select a View: