Forum Discussion
create reports by using two sharepoint lists
Hi, icsrit7
You can use the append function in power query to join the two tables so that they can be filtered together in the report.
Did I answer your question? Please mark my reply as solution. Thank you very much.If not, please feel free to ask me.Best Regards,Community Support Team _ Janey
hello jaipal,
i am giving you brief,
Infact, i have two list which contains same columns , the specified columns contains agreement year and agreement type.in that both list , column agremment type is a choice column contains same values and year column contains different time period like 2010 2011 2012 2013 . ( list A having set of year values and list B having set of different year values)
in this i need to pick values from agreement type agreement year from both list and make reports in number of agreement type in both lists by year.
I dont know how to get both list values integerate with single report.
Hope i am giving you brief ...
Hi, icsrit7
You can use the append function in power query to join the two tables so that they can be filtered together in the report.