Hi is there anyway i can have the Gross, Return, Total Disc, Net as selection. so user can click on the selection to display the data instead of all show at one table.
Example ,if user only wan to see Net, click Net, then the table only will show Net figure.
You can achieve this by checking "Drop down Select" option in presentation tab. Select the dimension and check the option. please find the screenshot for your reference below,
Since These are 5 measures and effect to all Dimensionality. not sure the way is existing. But work around may be attachment.
I hope I got your question.
You can create few buttons by setting a variable to it and apply conditional enabling in Expression.
For eg. if the user selects Net, it will show only Net Sales.
Hope this helps.