Filter non-zero rows based on Context Selector selection

Hi,

I have a filter to filter out non-zero rows with the employees across to top as columns and a total colum for the LOB (Line of Business). I have set the hierarchy so I can select LOB A or LOB B from the context selector or All LOBs.

Employee 1 // Employee 2 // LOB A

Project A
Project B
Project C

The issue is that Anaplan asks me to select the Filter Context on the filter which I need to select as All LOBs but this means when I select a LOB from the context selector at the top of the page, it does not filter out the non-zero rows for this LOB , it only works on the All LOBs level. So if Employee 1 and 2 didn't work on Project C then it is still shown as Employee 3 or 4 in LOB B may have worked on it.

Any ideas? Thanks in advance!

Accepted answers

All comments

Dikshant

It would be better if you could show the dashboard screenshots as well, but what if you pivot the module or grid differently and keep both dimensions, which are, I guess, project and time, in rows and line items in columns? That way, you will only see the months where you have any data.

If you keep them in rows and column, so for 1 project might not have data for that month but some other project has data for the same month, so anaplan will keep the month in the view.

Let me know if this is what you're looking for?

kristenr

@Dikshant - thanks - sent you a Pm

Dikshant

Can you share the filter applied to the grid?

kristenr

Here is the blueprint -

The formula in the Timesheet hours is

'DAT02 Timesheet Data'.Hours[SUM: 'DAT02 Timesheet Data'.Month, SUM: 'DAT02 Timesheet Data'.Resource, SUM: 'DAT02 Timesheet Data'.Task ID Revised] * PD Staff Factor

Thank you

kristenr

Do not have a solution to this one yet if anyone can help out?

PujithaB

HI Kristenr,

Please check the alignment dimensions in your view in the app,
If your Resource List is Context selector, then you have to apply the filter on the Context selector by selecting filter option but not on the View in the grid of the UX.

kristenr

@PujithaB - This is my UX page I want to filter Projects out that have zero value when I select a particular team.

Dikshant

Try to change this to —-current selection—- or something like that

PujithaB

Hi Kristener,

From the App View , I have understood that department is in columns and you want to filter out Non Zero columns only . This means your filter lineitem should have only dimensions of Columns which is departments and Page Selector which is Time,
Then Filter would workout without asking for ALL Lobs selection

But Since you have your data at two different dimensions which is department and projects
You have to place projects and departments on to the rows and time on the page selector and Lineitems on the Columns ,
Then filter wont ask for selection and the filter lineitem will work out for filtering

Thanks
Pujitha

garry_bh

Hi @kristenr,

Did you ever find a resolution to this problem?

Regards,

Garry

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.…