Hi All,
I've a report with the below columns - Product Line, Product Type, Product, Quantity & Revenue and I've three prompts Col1,Col2 & Col3 where user can select the required column to be displayed on to the report.
Inorder to implement the dynamic selection, I've used the below logic -
Product Line = #prompt('Col1','token','[Sales (query)].[Products].[Product line]')#
Product Type = #prompt('Col2','token','[Sales (query)].[Products].[Product type]')#
Product= #prompt('Col3','token','[Sales (query)].[Products].[Product]')#
However, if user doesn't select anything for col3 I am able to hide it from report context but how do I remove the column from Query Context.
Thanks & Regards
Raj