Ability to change Pivot in Google Sheets Add-on

Options
amit.paul1
amit.paul1 Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 4 Occasional Contributor
in Extensibility

The Google Sheets add-on doesn't let us change the dimensions in the Pivot when setting up the connection, unlike the Excel add-in. We need to create custom views in the model to be able to pull the data in the format we want. This is a big deterrent towards adoption of the Google Sheets add-in and restricts the self-service ability.

This is contrary to what is stated in https://help.anaplan.com/79a9b7f1-3908-458e-99a5-9214341e1f92-Create-a-new-connection - "Optionally, if you've selected a module, drag dimensions to pivot dimensions in the connection".

Ref Support Case No: 00333700

We would appreciate if this is addressed at the earliest as Customers are keen to use the add-on.

Tagged:

Comments

  • monikakocot
    monikakocot Member, ALL USERS Posts: 3 New Contributor

    Hi, 

     

    I agree with Amit it would be extremely helpful to have an option to pivot dimensions directly using Google Add-On. It's already possible via Excel Add-On. Is there a chance to have it added?

     

    Thank you,

    Monika

     

     

Categories