SQL dashboard report: Select table column dynamically

pawank9
New Contributor II

I am using SQL Dashboard report, there are around 400 columns in a table, I want to display some of the columns based on data, not all 400 columns should be displayed.

eg: a table have column named c1, c2,c3,c4 and rows r1, r2, r3, r4. The report should show columns as per the below scenario,

case 1: for row r1, the report should dynamically show c1 and c2.

case 2: for row r2, the report should dynamically show c3 and c4.

case 3: for row r3, the report should dynamically show c1 and c4.

Note: consider the report is showing only one row for now.