New UX Selectors on worksheets

Community! I'd like to follow up with @xin question regarding selectors in the new UX. And the answer @Puneeth H P gave in this response,which appears to only work for pages.

My worksheet uses one list, P6 SKU which is part of a structured Hierarchy (P1 to P6). I would like to use a selector on the top of the page that only goes down to P5 (I don't want to see the SKUs in the selector). Is there a creative way to make this happen, or do I need to switch to a Page, add a field card and sync it, as @Puneeth H P suggests? I've also added a card to the additional insights at the P5 level with the selector but no way to get it to the top of the worksheet that I can see.

Thanks, as always!

Accepted answers

Puneeth H P

Hi @JaredDolich

We can always publish the Grid with Dimensioned P6 Level in worksheet and show or hide the Levels we want to select in the Page Selector by editing it and show only P5 Level to select from PS .

But I'm afraid that in Level P5 , we can only view the data . But as asked , The page will be in Sync with the select we do from PS at P5 .

I hope I understood the scenario correctly here .

Thanks,

Puneeth HP

alexpavel

Hi Jared,

At least at this moment, I did not found a workaround for worksheets pages to solve this 😞

However, it seems that it's on the roadmap to be solved... 🙂

Hope it will be soon. Check below:

https://community.anaplan.com/t5/Idea-Exchange/NewUX-possibility-to-quot-Filter-quot-and-quot-Show-Hide-quot/idi-p/85417#M6778

All comments

Puneeth H P

Hi @JaredDolich

We can always publish the Grid with Dimensioned P6 Level in worksheet and show or hide the Levels we want to select in the Page Selector by editing it and show only P5 Level to select from PS .

But I'm afraid that in Level P5 , we can only view the data . But as asked , The page will be in Sync with the select we do from PS at P5 .

I hope I understood the scenario correctly here .

Thanks,

Puneeth HP

JaredDolich

@Puneeth H P

Good call out. However, the worksheet grid is filtered on P6 only. We want to see P6 on the worksheet, but not in the selector. That's the trick. Your idea will work great on a page though!

alexpavel

Hi Jared,

At least at this moment, I did not found a workaround for worksheets pages to solve this 😞

However, it seems that it's on the roadmap to be solved... 🙂

Hope it will be soon. Check below:

https://community.anaplan.com/t5/Idea-Exchange/NewUX-possibility-to-quot-Filter-quot-and-quot-Show-Hide-quot/idi-p/85417#M6778

jnoone

@JaredDolich yeah you're right, I don't know of a good way other than what you mention. I've been using KPI cards in the insights pane since it's a little better visually but also have upvoted the roadmap item for this.

JaredDolich

@jnoone thanks. Well, I got it to work on a board because we can use the filter and/or the view levels feature. Not ideal because I really like the sliding panel of the additional insights. Thanks for upvoting!

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…