conditional - Cognos - Conditionally hide a column, and summarise the remaining columns -

conditional - Cognos - Conditionally hide a column, and summarise the remaining columns -

i have study static selection on prompt page. user can take 'full detail', or 'summarised'.

for simplified example, study has these columns: customer, product, date, quantity, value.

i able show/hide date column based on detail level choice, , have quantity , value columns aggregate single customer/product line. know how show/hide column (tying selection variable column's render variable), not aggregation, makes column invisible.

i have thought doing separate study page total detail , summary, in actual study have sec selection box user can take field summarise (e.g. client or product), , study section-group field. @ moment doing 1 per page (5 of them). doing detail selection same way mean need 10 pages. there certainly improve way.

full detail:

client product date qty value abcd things 22/10/2014 10 1.00 21/10/2014 40 4.00 23/10/2014 50 5.00

summarised (how looks @ moment, after hiding date column):

client product qty value abcd things 10 1.00 40 4.00 50 5.00

summarised (how look):

client product qty value abcd things 100 10.00

i using cognos study studio 10.1.1

you should not hide column. should set same value column in rows instead of [date] in column set

if (?hidedate? = 1) ('') else ([date])

or, if prefer case

case ?hidedate? when 1 '' else [date] end

replace ?hidedate? = 1 own condition

conditional cognos