nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Pivoting cards on Excel365

matthewman

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

Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…