3 of 4 people found this helpful
You can use Dashboard Actions to perform this operation.
Create a new report, and add the relevant dimensions and measures you want to see on the report i.e. Vendor related and recv loc nbr etc.
In actions, select Source sheet as sheet1 and target as Sheet2. Sheet1 is the sheet you have given, sheet2 is the sheet that I am asking you to create.
Please refer to below link for use of filter actions. You will have to pass Mer Vendor NUmber as field in the filter.
Hope this helps.
2 of 2 people found this helpful
By using actions we can do this .
Create new worksheet which contains details info of vendor and lco number .
Now by using actions link b/w this two worksheets.
Thank you Abhilash!! I'm able to accomplish the requirement!!
Is there a way to export the data from each sheet in the dashboard via excel? When I export in excel, I could see the results only from sheet 1.
Thank you! Using Filter action is working fine.
1 of 1 people found this helpful
That is happening, because when you export as excel you will get individual dashboard as output. You will have to take both exports separately to view both dashboards.
Please do mark the reply as helpful if it helped you.