Loding Multiple cross tables from Muultiple Sheets of Excel
I’m trying to load multiple cross tables (Same fields just different years data) from multiple sheets of an excel and had no success. I did lot of research in the forum still I’m not able to resolve my issue. So I’m here for help please help me.
Attached script is working if I load year by year but I want to load all the sheets at a time as I want to make it dynamic.
I have attached the qvw I was working and also attached the sample excel with 2 sheets (2016 and 2017) data. Please help in trouble shooting the issue or please suggest if there a better way of doing it. Thank you,