IBM Support

IBM Planning Analytics For Excel: How To Add A Blank Row or Column In A Univeral Report

Troubleshooting


Problem

How To Add A Blank Row or Column In A Univeral Report

Resolving The Problem

You must create an Exploration Report with the blank row or column (s) and then convert the Exploration report to a Universal Report

STEPS:

1.In Planning Analytics For Excel, create an Exploration Report
2.Select IBM Planning Analytics at top menu
3.Select the row or column heading where you would like to insert the blank row or column
4.Right click and select IBM Planning Analytics from the pop-out menu (it will be the first option)
5.Scroll down the list of options and select Insert User row or Column (the option appears towards the bottom)
The blank row or column is inserted in the Exploration Report

NEXT
6.Select Exploration tab at top>select Convert to> and select Universal Report

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"ARM Category":[{"code":"a8m50000000KzLFAA0","label":"Planning Analytics-\u003EPlanning Analytics For Microsoft Excel-\u003EModel and Reporting"}],"ARM Case Number":"TS014760367","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
07 December 2023

UID

ibm17091614