How to hide a worksheet based on a condition
Hi all,
I am creating a BI publisher template via Excel. It will contain 3 worksheets. Is it possible to hide a worksheet based on condition? User will select a value from parameter list called reports. This reports lov will have following values (All, A , B, C)
If user selects All, all 3 worksheets should show. If user selects A only that worksheet sheet should show etc. Can this be done?