Hello everyone,
Thank you in advance for your help. I've an idea althought I dont know if it is possible.
We have a sharepoint list similar to this one in which each assigned analyst have to attach an excel document in astandarized manner in each row. Every row contains only 1 excel file and all of them have the same structure (Number of columns, names of the columns, etc).
Now I was able to Merge the files by using this helpful guide, but the problem is that I need to filter my sharepoint data BEFORE merging the files and by using this method it wont give me the option.
IE: Filter the data by "Argentina" Only and THEN merge all of the excel files.
Is there any workaround for this?
THANK YOU!!!
Filtering after merging is a relatively simple method. You can apply the filter directly to the corresponding column after merging, or create a parameter to filter items.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
119 | |
74 | |
65 | |
53 | |
51 |
User | Count |
---|---|
184 | |
104 | |
82 | |
79 | |
78 |