Filter line Item

So I have a module wherein there is 13 line items. 1 is a Text Line Item (text formatted) and the other 12 are Jan Feb.. Dec (12 months number formatted).

I'm not using the native Anaplan time. I however want to filter the display of months based on the version selected (not native version). Say if it's Version 1+11 which is selected, only Jan should be displayed, if it's 2+11 only Feb and so on. I would also want the Text line item to be displayed irrespective of the selection of the version. Is there a way to do this on Anaplan. I did try line item subset however, that doesn't show the text line item that I have.

Can someone help me with a workaround for this problem, it would be really helpful for us. Thanks

Accepted answers

All comments

Misbah

@Sachinsourav02

Without getting into details of why line items for Time, here is what I think

1. You can create a LIS for Time and insert two line items one for Number and another one for text. You will have to use Hide/Show on Text Formatted Line item to show it only once

2. You can show them in two separate grids side by side, New UX allows you to hide the Row dimension in such a way that adjacent grid looks like extended grid.

Sachinsourav02

Hey thanks for the quick reply.

I wanted the whole thing in one grid instead of two. And I am currently using LIS for the months and it appears correctly just the TEXT formatted line item doesn't appear. Is there any other way like 'nested IF' or something to make it more simpler.

Misbah

@Sachinsourav02

I wish I had a better answer but with LIS, text is ignored which means whatever you need to get the text populated you will have to stick to it and then from the presentation perspective you may have to use Hide/Show as well.

Sachinsourav02

Let me try and look for other workarounds. Really wish I figure something. Thanks for the suggestion but. 🙂

ChrisAHeathcote

@Sachinsourav02

The only solution I can see here is to map your month line items into Anaplan time periods.

Then filter based on a filter module dimensioned by fake version and month time.

I would question why you are representing time data in a line item and aim to utilise native Anaplan time functionality.

Good luck,

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