I am trying to apply a filter in a line item, which is used list as format and is subsidiary view.
Hello,
Applying a filter to a line item (formatted to a list) is as simple as clicking the Filter icon and creating the filter. Sometimes its easier to select the line item and then click the filter, because that usually creates the basic filter for you (and then all you have to do is select the values you want to filter to in the filter dialogue box).
If your question is a little more involved, lets say you want to be able to filter to a line item using a selector in a dashboard... well, that's a horse of a different color! If that's the case, you probably want to use User Level Filters. Take a look at this post for an example: https://community.anaplan.com/t5/Training-General/Filter-on-List-Items-based-on-another-List/m-p/30182#M224
Cheers!
Hi Paul,
Thank you for your response.
I am facing issue with filtering line item ( line item used list as format and is subsidiary view ) publised in dashboard.Its showing “Unsupported Operation 'Filter' ”.
That is limitation or there is any way to apply filter on line item(used list as format and is subsidiary view) publised in dashboard.
I can apply a filter in a dashboard using a line item that is a subsidiary view.
Can you pls share images of the report you want to filter in the dashboard, as well as a blueprint view so I can also see the subsidiary view line item?
Kindly find attached dashboard line item and blueprint, where I tried to filter but using the filter I got an error that "Unsupported operation filter". and when tried filter list option, pop up was coming but no value available in the drop-down.Line item used list in format and is subsidiary view.
Hi,
The feature is working on my end using a subsidiary view line item formatted to a list. I do see that you have some values populated (and some blank)... the pick-list will only include list items that are being used in the subsidiary view line item.
There are times when the nature of the pivot prevents filtering.
If you can provide a full blueprint view of the module (really just the main columns), as well as a fuller picture of the dashboard, we can take a close look.
Hi @chp127,
The replies from @PaulRitner are true. We would like to know what you are trying to achieve here.
The ways that you can apply filter are as follows in the snapshot that I have provided you.
1) You have created a subsidiary view
2) Here you have to go inside the view and then publish it to the dashboard.
3) In the dashboard, you can apply the filter as you like.
4) The unsupported filter operation is due to applying it straight on top of the subsidiary line item. That is the case when it shows 'Unsupported filter operation'
Now, what I did was try to recreate the error that you got. There are other ways in which you can go about and achieve what you want to achieve. This is one of the ways you can do it. Hope this helps. Let us know whether it served your purpose.
Thanks,
Adithya
Hello everyone, We are trying to use Anaplan Connect in order to push data from a dwh to Anaplan Data Hub. To do so, we need an authentication by token. We can't make it work, we receive the following error: ERROR 16020 |-- Anaplan API: Invalid key path Any suggestions? Thank you all in advance for the help! Michele
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…
