Step 1: In this example, we'll use our 'Finance' database, and prepare our grid as shown below, with these selections: Variance mode, 'sub account' dimension, financial YTD, and three items selected: Stationery, office consumables and postage.
Step 2: Choose Chart and select bar .
- The x axis displays the total. This always starts at zero.
- The y axis depends on the mode. In period mode and moving mode, the y axis will display the time units of your current period (e.g. months/days/years). In variance mode, stream mode and total mode, the y axis will display each focused item in the current dimension.
The office expenses this YTD are shown in blue vs. last YTD in red. The chart can now be saved as a favorite or added to a dashboard.