Help Needed - How to Show conditional fields based on selections

[#1]

Hi to All!

My problem its that i have more than 130 columns and i need to show some columns based on a selection of an specific field

For instance

I have 130 columns with datas and other columns. Lets suposse that i have to Show the Month on rows and 130 columns on a table or pivot table.

As i have so many columns i have a separated table with: 130 rows from 1 to 130.

So, on a filter have the 130 values on the separated table.

So, i need to filter on this table those values that i wanna to see on Pivot chart. Something like that:

If i select values 1,2,3,4 and 6, i have to get the follow result:

Month	1	2	3	4	6
1	100	100	250	200	150
2	100	250	300	100	100
3	50	150	200	300	250

But, if i select the values 3,4,20, i have to show:

Month	3	4	20
1	250	200	125
2	300	100	200
3	200	300	150

I hope to be clear. Please, HELP!

Thanks!!!

[jerem1234]

Maybe add | at the end and beginning of the selection list of what Mayil did, that way it can sort of denote an "end" and "beginning" character then search for '|#|'

Try this formula for the dimensions, for example 1:

Index('|' & GetFieldSelections(FieldSelection ,'|',100)&'|','|1|')

Hope this helps!

Made an edit: Need a beginning character as well.

[#3]

Im sorry but im trying all sugestions but, nothing seems to work fine.

Here its the example of my file.

When i select numbers between 1 to 7, works fine.

But, if i select 29, por example, i see incorrect columns...

[jerem1234]

I edited my last reply to have a beginning character as well as the ending, I think that should solve it.

Did you try it that way?

[jerem1234 · Accepted solution]

I did from 1-30, and it seems to be working with the new beginning character.

PFA

Hope this helps!

[#6]

Thanks Jerem!!!  Correct!!!

Thanks a Lot!!!!

[#7]

Finally, the correct formula was:

=   Index('|' & GetFieldSelections(Campo ,'|',$(vMaxCampo))&'|','|1|') or if(len(getfieldselections (Campo) )=0,1,0)

Thanks to All for Help Me!!!!!

Regards!