I am trying to export the Item list that has nearly 3000 records to Excel after changing the view to Analysis Mode. I have added the vendor name field to the analysis mode using add columns from button (Vendor Number of Item => Name of Vendor). I tried 2 options to export to excel.
1. Right click on the middle of the analysis mode result and clicked Export > Open in Excel button. I could export only 200 rows.
2. Click Analysis Mode button at the top left. And clicked the Open In Excel from the drop-down. I could export only 100 rows.
Is there a way to export al items at once when we are in analysis mode with some related table fields added. Thank you.