Analyzing Trends in the OpEx by Account Dashboard
The OpEx by Account Dashboard shows the OpEx by Account Trend and OpEx by Account year-over-year (YoY) variance graph. You can use this dashboard to analyze OpEx trends and YoY growth variances by Account for the selected Department. You can view the trends an amount or percentage of total expenses. The subforms include the option to drill into specific Accounts.
This section includes general instructions on how to use the following interactive subforms OpEx by Account Dashboard:
-
OpEx by Account Trend – Displays 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.
-
OpEx by Account: YoY Variance – Displays the percentage variances for the selected Department between the current and previous year by month's, year-to-date, full-year, and next year variances. 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 Dashboards, click the 2 tab on the left-hand side.
-
Click OpEx by Account Trend.
-
In the Point of View (POV), select a Version, Subsidiary, Currency, and Department.
If you use Dashboards 1.0, click the Go icon
to apply the changes to the POV. -
To review the YoY variance percentage by Account:
-
From the dropdown list in the OpEx by Account Trend subform, select one of the following options:
-
To see the graph by value, select Amount.
-
To see the graph by percentage of the total revenue, select % of Total Expenses.
-
-
If you use Dashboards 1.0, click the Go icon
in the OpEx by Account Trend subform to apply the changes. -
(Optional) Click on a line in the graph or click the Account name in the legend to drill into the Account's operating expense.
-
-
To review the YoY variance percentage by Account:
-
Hover over a series bar in the graph to see the series name and variance percentage.
-
(Optional) Click a bar in the graph to drill into the Account's operating expense in relation to the Department selected. Alternatively, click the Department name in the legend.
-