How to remove a dataitem from Query Context

[raj_aries81]

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