Time filter not working properly

Sai_Bharadwaj_Venati · 2023-01-12T10:54:57+00:00

There was an error rendering this rich post.

Hi everyone,

I have a grid where i show Products in rows, time/multiple line items in columns (Sales, Py Sales, %growth etc..).

I want to control the time dimension based on selector provided to user (Attaching Screenshot).

There is a final time filter line item and it is at month level and works fine if i use it when single line item is published or when line items is used as pages.

This final time filter is not working when multiple line items published on columns

(Expected Output)

(Currently it is showing blank)

Accepted answers

All comments

megha09

Hi @Sai_Bharadwaj_Venati

I am not sure what logic you are using for your final filter but here is mine which works even when there are multiple line items published as column. Make sure the summary for Final filter is formula. Please refer attach screenshots for better understanding.

Thanks

Sai_Bharadwaj_Venati

Hi,

Thanks for the reply. I have the same filter with same formula. It's working in backend but on new ux it is not working

megha09

Hi,

I have tried publishing it as custom view and saved view both and it still works on New UX. Few things you can check -

Allow editing option is enabled for both grids

Apply filter after pivoting your grid on the Board.

Thanks

Sai_Bharadwaj_Venati

Okay thanks, still unresolved though. reason being i have 3-4 dimensions in my module

andrewtye

Also don't forget that if you've applied a filter and then repivoted the filter always breaks so needs to be reapplied.

tomgilbert

@andrewtye hi Andrew- is there a reason why the filter always breaks after pivoting? This has been a major painpoint for our users and we're hoping to find a solution.

andrewtye

@tomgilbert - that i don't know. might be to do with things not persisting or if you've got a board with multiple tables and the context selectors don't allign. See you've added a question so let's see what people think!

sobaid

@Sai_Bharadwaj_Venati Could be the possibility , when in UX page while you are applying this " Final Filter" make it as any under

Show items that all/any of the following ,under filter diaglog box.

Quick Links

Can you help?

Unanswered questions

Has anyone taken a stab at Master Anaplanner Recertification exam yet?
Just curious :)…
Solution for indent diabled for hierarchical list when the page has more than two axis
Hello fellow Anaplaners, I have a question about the UX for Anaplan for hierarchical list. If I have a list with multiple layers, say P1, P2, P3, and P4, and the workpage had 2 axis, list and line items, in its vertical axis and time in its horizontal axis (see figure below) The list is shown without indentations, and may…
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…