Register

Excel Add-in: drag and drop dimensions, view line item formula, keep only/exclude

Excel Add-in: drag and drop dimensions, view line item formula, keep only/exclude

Please add the following features into the Anaplan Excel Addin -

1) Ability to pivot by dragging and dropping members within the spreadsheet rather than clicking on pivot and filter.

2) Ability to drill down a hierarchy by double-clicking in the spreadsheet

3) Ability to extract just one data intersection using some formula like CHOOSE or GETVAL, given the user can provide member names for all dimensions required to extract that value - rather than extracting the entire module.

4) Provide the ability to push information into modules using the Anaplan 3.0 Excel Add-in

5) Provide ability to view formulas for line items in the spreadsheet

6) Provide Keep only/ exclude only functionality

 

All of these basic functionalities would make Excel Addin really useful.

 

4 Comments
Stan
Community Manager
 
Status changed to: Your support is needed
Miran
Community Manager
 
Status changed to: Your support is needed
MagaliP
Community Boss

Thank you very much for these suggestions.I believe you mean read-write connection in your point 4, if this is the case, it has been delivered in v3.3.

All the other ideas are brilliant and still need Community support.

MagaliP
Community Boss

1) Ability to pivot by dragging and dropping members within the spreadsheet rather than clicking on pivot and filter.

 

2) Ability to drill down a hierarchy by double-clicking in the spreadsheet - tracking in this idea

 

3) Ability to extract just one data intersection using some formula like CHOOSE or GETVAL, given the user can provide member names for all dimensions required to extract that value - rather than extracting the entire module. - tracking in this idea

 

4) Provide the ability to push information into modules using the Anaplan 3.0 Excel Add-in - delivered

 

5) Provide ability to view formulas for line items in the spreadsheet

 

6) Provide Keep only/ exclude only functionality

New Solutions
Anaplan Platform
Epratt
Occasional Contributor