SUM needed instead of time buckets

[Former Member]

Hi,

In the interactive planning book, I have the data for teh key figures displayed in some time buckets. At the end of the forecast, I need to have a column with name SUM and adding all the data of the rows. I dont want to create a new key figure for calculating the sum, but needed a column named SUM at the end. Please tell me how I can do that.

[Former Member · Accepted solution]

Hi,

In trasaction /sapapo/sdp8b. Open your planning book in edit mode. Goto to Dataview Tab. Look for this field 'Initial Column' you can choose the placement of that extra column you need.

Then you can write a macro to populate that with that whatever value you want. now since it is a macro, you can define it to be default, on save and so on...

Hope this is helpful.

Thanks

Mani