Synchronize Columns based on Version Selected

Hi All,

We have in our dashboard around 10 Columns to be displayed and two versions as selector.

6 Columns will be same in both the version but next 2 columns to be displayed in one version and remaining 2 columns to be displayed in the second verions.

So if the user selects verison 1 then 8 columns ( 6 Common Columns + 2 columns for version 1 data ) to be displayed only and rest 2 columns whic has version 2 data to be hidden.

When the user will select version 2 then 8 columns ( 6 Common Columns + 2 columns for version 2 data ) to be displayed only and rest 2 columns whic has version 1 data to be hidden.

Thanks

Accepted answers

All comments

DavidSmith

@NakulAggarwal

I think this is same issue as this post:

https://community.anaplan.com/t5/Dashboards-and-Visualization/Dynamically-filtering-line-items-based-on-version-selected-on/m-p/37141

Which I've answered. Use a Line Item Subset to create a filter module and apply to the target module

Cheers

David

NakulAggarwal

Hi David,

@DavidSmith

Thanks for the valuable reply,

As tested a Line Item Subset can only be used where there is a Numeric Value format. But in case where there is a text format or a List format line item, we can not select it.

So to filter the same what can be done.

Can you please help us on the same ?

tagging @saurabh.raheja to keep him updated for same issue.

Thanks.

DavidSmith

@NakulAggarwal @saurabh.raheja

I've thought long and hard about this because it is really challenging. The only real way I can think of is as follows, but depending on your exact requirements it may not be a practical solution

1. You'll have to define your line item measures as a list

2. Create a mapping module like we had previously mapping the measures to versions

3. Create subsets of the measures list by "type", so you contain all of the numeric items in one subset, all the Booleans in another, dates in a third etc.

4. Then you create separate modules for each type using the subsets from 3. and filter based on the mapping on 2.

5. Hopefully (!), you csn then display these on a dashboard together so that all grids syncronise to the filter when the version is selected

I hope this is useful

David

saurabh.raheja

Hi @DavidSmith

Thanks for the quick response and solution to our unusual question. We have used part of the solution for all the number format line items by creating mapping module using the line item subset as suggested. Rest we thought long and hard and finally resolved that since we had only a few line items with other than number format, we created a separate view on the dashboard for these line items. I didn't quite grasp what you mean by the 'subset by type' for all the other type of line items like boolean.

Would appreciate if you could share a small example on what exactly you mean.

Again thanks for your support.

Saurabh

Quick Links

Can you help?

Unanswered questions

別ディメンションで、セレクターをモジュールに返し、計算したい
下記のようなことがしたいですコンテキストセレクターの値を別モジュールに反映し、それを使って計算したいです。 selecter A-1 Dim code amount Select→ A-1 1 100 A-2 2 100 A-3 3 100 A-4 4 100 module Dim code amount key Flg A-1 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 2 2 50 A-2 FALSE 2 2 50 A-2 FALSE
Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
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…