Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Displaying dynamic columns in the query output.

Hello,

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

Shilpa

replied

hi shilpa,

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

thanks,

Rk

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question