COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: beerguy82 on 31 Jul 2009 07:42:06 AM

Title: Using a total() function and a multiselect prompt to roll up values
Post by: beerguy82 on 31 Jul 2009 07:42:06 AM
All -

I received a report request where the user wants to be be able to be prompted for discreet time periods, select multiple, and have a measure roll-up across those time periods.  I have tried doing it as follows, but it doesn't seem to work.  Any other ideas?

total([Quantity] for [Package Type],(#promptmany('pTimePeriods')#))

Thanks.

Tim