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

Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…
PowerPoint Add-in: Installation requires elevated privileges
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed. Issue For versions 1.6, 1.7 and 1.8 of the PowerPoint Add-in elevated privileges are required to install the add-in through command line and for the "all users" option. Workaround * Installing through…