Skip to Content

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

Restricting data in cross tab report


I am creating a cross tab report.In that I want to restrict the column dynamically.The column depends upon the parameter field.

say for example if i enter the parameter as 2007,it should display field from 2004-2007 only rather than displaying all years.

Thanks in Advance,


Former Member
Former Member replied


You can use a formula. e.g

< Basic format>

Select case year({Command.tradeDate})

case 2005 to 2007

formula = 1

Case else

formula = 0

end select

Then on the crosstab column group options, choose "specified order" and on the "Other" tab choose "Discard all others"

Hope this helps



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