Analyzing Trends in the OpEx Trend Dashboard
Use the OpEx Trend Dashboard to to analyze operating expense trends. The OpEx Trend Dashboard shows OpEx trends by Department for the selected Account, and by Account for the selected Department. The subforms also include the option to drill into specific Departments for the selected Account, or into specific Accounts.
This section includes general instructions on how to use the following interactive subforms in the OpEx Trend Dashboard:
-
OpEx by Department Trend – Uses Actual and Forecast values to show the trended historical to projected operating expense by Department for the selected Account. You can see values as an amount or percentage of total expenses. The subform includes the option to drill into specific Departments for the selected Account.
-
OpEx by Account Trend – Uses Actual and Forecast values to show the trend by Account for the selected Department. You can see values as an amount or percentage of total expenses. The subform includes the option to drill into specific Accounts.
To analyze the operating expense trends:
You can maximize and refresh each trend graph individually by clicking the Maximize icon 
and Refresh icon in each subform 
, respectively.
-
From the Home page, Click the OpEx card.
-
To go to OpEx Planning forms, click the 1 tab on the left-hand side.
-
Click OpEx Trend Dashboard.
-
In the Point of View (POV), select a Version, Subsidiary, Currency, and Tracker member. For Tracker, select one of the following options:
-
To see the graph by value, select Amount.
-
To see the graph by percentage of the total expenses, select % of Total Expenses.
-
-
If you use Dashboards 1.0, click the Go icon
to apply the changes to the POV. -
To review the operating expense trend by Department for an Account:
-
In the OpEx by Department Trend subform, select an Account in the Account list.
-
If you use Dashboards 1.0, click the Go icon
in the OpEx by Department Trend subform to apply the changes. -
(Optional) Click on a line in the graph or click the Department name in the legend to drill into the department's operating expense. Drilling shows the operating expenses at the individual Account level.
-
-
To review the operating expense trend by Account for a Department:
-
In the OpEx by Account Trend subform, select a Department in the Department list.
-
If you use Dashboards 1.0, click the Go icon
in the OpEx by Department Trend subform to apply the changes. -
(Optional) Click a line in the graph or click the Account name in the legend to drill into the Account's operating expense.
-