I need the user to be able to filter the combos in the rows. For instance, when they select combo 1, the time dimension in the column should display with non-zero values corresponding to combo 1.
@143kishornaidu it is still possible to achieve the result. Refer to the below screenshots
You need to pivot Combo list and Time both to rows. Does this view works for you ?
Combo 1
Week 1
Week 2
Combo 2
Combo 3
Week 3
user needes week in column and combo 1 in rows onluy
So if Combo 2 has Week 3 but Combo 1 does not have Week 3, still it will show Week 3. Is it fine?
no i user want to see only those weeks only which has value for that combo
It's not possible with the time in columns and combo list in rows. It's possible when both the lists are in rows or in columns
You can create the impression of selecting rows from the same grid by placing the modules side by side on UX pages.
UX Page:
Modules:
Does this work?
Hi @143kishornaidu
You can keep the Combo's list in the Page selector as you want them to be a selector and create an additional line for filter in the module which drives the condition for making columns visible as required. Refer below screenshots:
Thanks!!
BUt the combo having multiple combinations.
eg: Dim1IDim2IDim3IDim4
User wants a line item filter. Also, user is filtering the Dim 1 and Dim2 In Line item filter
You can have the other dimensions as page selectors.
@Slice Master You can drag a field into the “Filters” area of the PivotTable Field List to create an overall filter that applies to the entire pivot table.
We have an Anaplan model that uses "Fake Time" - that is a time dimension specifically constructed for the application and not one found native to Anaplan. For this reason the Opening / Closing Balance summaries don't work. We would like to be able to show the opening and closing balance at the beginning end of each weekly…
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…
