dynamic column in table visual

[Anz]

i want to show the value for attributes for all quarter like if we have only data for Q1 i want to show Q1 and the last month of Q1 and dont want to show data for other quarter as they are not present. if we have data for Q2 then  we want to show the Q1, last month of Q2 and Q2 and if we have data for Q4 the we want to show the Q1, Q2, Q3 , last month of Q4 and Q4. and if any of the quarter having no values we want to filter it out from table visualization.(last month means if Q1 has october, november and december and we have value for october and november we want to show value for november and Q1.) 

[danextian · Accepted solution]

Hi @Anz ,

That is not possible with a table visual as: one, the column/field names  cannot change dynamically and, two, whatever column/field you place in there is what will appear. That is possible with a combination of matrix and a disconnected table that will hold the names of the columns you want. Attached are sample files to help  you get started with.

[Anz]

@danextian  Is it possible to filter out column in table visual which do not have any values?