Create a formula for your summarised field and use that:
if {?SuppressColumn}="Yes" and
(Table.ColumnField}="Don't want to see this" then 0
else {Table.ValueField}
Then set the crosstab to supress Empty columns. I think that property is available in 8.5. Don't have that version on my current machine.
Interesting Question. Might put this in our next newsletter.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.