Clean up the balance sheet

You have created Balance Sheet report that shows assets, liabilities, and equity for the Sample Outdoors Company in 2013. Finally, you must now clean it up.

Procedure

  1. Under each balance sheet category, remove the row that contains the labels for the dimensions that were used in the cell-based analysis.
  2. Ensure that empty rows are deleted so that the balance sheet maintains its form.
  3. After converting the data to static data, the summary items, such as Other assets (total) and Current liabilities (total), are static values. Remove these rows so that the balance sheet template formulas calculate the data accurately.
  4. In a cell where you would like the heading of the balance sheet, type Great Outdoor Company Balance Sheet and 2013.

Results

You have used your Excel knowledge to augment IBM® Cognos® data. If you need more help, see Create from scratch.