Display only columns with filtered value

[Matt]

Hello, i have a table f.e. like this

Name_of_bank | Total_count | Year 2017 | Year 2018 | Year 2019

ING                         | 2                       | 2                  | 0                   | 0

Erste                      | 5                       | 1                  | 2                   | 2

And so on.. In filter I choose Year 2017.

My questions is, is it possible to display in the table only column Year 2017. If I choose different year, display only filtered year.

If not, do you have an idea how to do so?

Thank you in advance.   

[jonathandienst · Accepted solution]

Perform a cross table load to convert your cross table to a conventional table for analysis.

Result:
CrossTable(Year, Value, 2)
Load Name_of_bank, Total_count, Year 2017, Year 2018, Year 2019
From ...

If you would like the years as numbers, you need one more step:

T_CROSST:
CrossTable(T_Year, Value, 2)
Load Name_of_bank, Total_count, Year 2017, Year 2018, Year 2019
From ...

RESULT:
LOAD Name_of_bank, 
	Total_count,
	SubField(T_Year, ' ', 2) as Year,
	Value
Resident T_CROSST;

Now you can create a list box with Year and see the results for the selected year.