Displaying dynamic columns in the query output.
Depending on current quarter output of the query would vary.
If current quarter is 'Q1'
O/p : InvQ1 Del BackQ1 BackQ2 BackQ3 BackQ4
If current quarter is 'Q2'
O/p : InvQ1 InvQ2 Del BackQ2 BackQ3 BackQ4
If current quarter is 'Q3'
O/p : InvQ1 InvQ2 InvQ3 Del BackQ3 BackQ4
If current quarter is 'Q4'
O/p : InvQ1 InvQ2 InvQ3 InvQ4 Del BackQ4
So, out of 9 columns, 6 columns would display at any given time depending on the current quarter.
Invoice of 4 quarters, Deliquency and Backlog of 4 quarters.
I am not getting any way how to display dynamic columns or hide unwanted/blank columns.
For the time being I have added all 9 columns in the query, and in the output unwanted columns shows blank.
Can anybody please suggest me how to display only 6 columns in the output depending on current quarter.
Thanks and Regards
Rama Krishna replied
you can hide the columns with all values having zeros by making the following setting:
In properties of structure, check "Also use zero suppression for structure elements" and In query properties under display tab, select suppression = active(all values=0) and effect on = columns