cancel
Showing results for 
Search instead for 
Did you mean: 

Add button for quickly adding/removing planning level

Former Member
0 Kudos

My question will sound very strange to you but it's an actual client requirement.

In Excel, is it possible in a way (for example via macro) to add a button that automatically adds/removes an attribute from the displayed planning level? The client does not want to click on "Edit view" and make the changes.

I tried already but it does not seem possible.

Accepted Solutions (1)

Accepted Solutions (1)

former_member194529
Active Contributor
0 Kudos

Hi Silvano,

I don't see any way to accomplish this request in the current functionality. The Edit view option would be the only possible way to perform the change at the moment.

Best regards,

Ivan

Answers (3)

Answers (3)

Former Member
0 Kudos

Hello Vanam,

Yes, I think that is a new feature from the Excel UI from 17.02

Best Regards,

Silvano

lingaiahvanam
Active Contributor
0 Kudos

Hi Silvano,

I hope this functionality will helpful to business.

IBP 1611 version drill down option available, if user wants to drill down aggregated value dis aggregate by different attributes at that planning level.drilldown.jpg

Attached image.

Best Regards,

Lingaiah

Former Member
0 Kudos

Ok, yes I thought so too. It was just a client question. They are working with Excel spreadsheets and are used to that...

Thanks,

Best Regards,

Silvano