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
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…