Showing Data Based on Selection

[#1]

I want to show sales data based on selection. Example enlcosed for your reference.

Master Table is showing actual data I have in excel sheet.

TABLE I WANT is the table I want based on selection from LIST BOX named PLEASE SELECT.

Everything looks perfect... Now I want Product Name should be appeared as third column while I select ProductID.

i.e. While I select ProductID in PLEASE SELECT LIST BOX... below table should appear.

ProductID	ProductName	TOTAL
PRD 001	FILES	23000
PRD 002	MOBILE	85000
PRD 003	NOTEBOOK	11500
TOTAL		119500

But if I select CustomeName or CustomerCountry, only two column should appear.

Is it possible...

Waiting for your kind reply...

[#2 · Accepted solution]

You need to add the expression (ProductName) and put a condition in the Presentation tab for that column.  If you use:

if(GetCurrentSelections() = 'Selection: ProductID', 1,0)

that should work for you.  If it is 0 it will be invisible, if it is 1 it will show. 

[#3]

Thanks for your quick reply. It is working absolutely fine.... 🙂