Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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.
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.
Thanks for your quick reply. It is working absolutely fine.... 🙂