Pivoting cards on Excel365

Hi,

We are not allowed to import data from a saved custom view and we are never allowed to pivot a template from saved view. So when are we allowed to pivot a card?

Thanks.

Accepted answers

All comments

Dikshant

Hey, Can you please give more context here? Are you using the Excel add-in, extracting the data from Anaplan Saved View into Excel, and then trying to pivot?

matthewman

I was using Excel Add-in for Office365.

My step was -

create a saved view from a module
go to the UX page and create a grid from saved view
save grid as template on UX
on Excel add-in, choose saved template

Then I tried to pivot on Excel.

Hope this helps!

SriNitya

Hi
When you create saved view you cannot pivot the grid(pivot option gets disabled) but for custom views you can pivot the grid.
If you take the export of saved view in excel 365 you can pivot the grid.

matthewman

Hi - I think I have tried to, but failed to create a view from custom views on Excel 365.

Stated on Anapedia:

https://help.anaplan.com/anaplan-for-microsoft-365-a90600ae-7ae8-42cb-824b-25aea2069c0c

SriNitya

https://help.anaplan.com/pivot-card-data-in-microsoft-365-3416e257-176f-4690-82e7-f7ad03e1ec81
Hi this article provides more detailed information on Pivot card data you can refer it.
Hope it helps

PujithaB

Hi @matthewman

When you are pivoting are you applying any show/hide or filters
If yes, there are few known issues and workaround.
Please check those in the Known issues Section

matthewman

Hi @PujithaB,

There were no show/hide or filters applied.

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!