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

gsarin

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.

 

Stan

Status changed to: New

Miran

Status changed to: New

MagaliP

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

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

Thelint45

Use a formula like CHOOSE or GETVAL to extract a single data point by providing member names for all dimensions - edited by geometry dash meltdown