I think you can do this kind of things through Dashboard, but it's much easier to start to tackling this after seeing your own data.
Could you share your workbook as packaged with tableau version info ?
Thank you for your reply. I started creating the dashboard from the sample workbook. I attached the same to the main entry. I don't see an option to attach to the reply.
Here is something to get you started. There are a lot of avenues to go down with aesthetics and actions but this is the simplest.
Some things I did to clean up what you initially had: Removed the ABC from the text shelf, put all fields in order sheet then increased fields, and then made the filter affect all sheets.
Attaching 9.2.4. workbook
Thank you Daniel for your reply and cleanup of the workbook. Thanks for the tips.
Is it possible to display the customer details in horizontal rows, like transposed data?
It is possible to transpose the data, you may use data scaffolding technique. Just search it on forums and you'll find too many posts to use that technique. Data scafolding works just like pivot and unpivot of data using by datablending in tableau.