Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.