I need to create a custom view from multiple related lists. List A has a drop down field that I would like to use the value to create a custom view. List B contains payments received for each of the items in List A monthly. I would like to create a view that displays List A Value 1 with all the related List B Values and then shows the total amount received of all the items in List B. To further complicate things List B spans multiple years and I need the user to be able to Select the Year and then the Drop Down Value in List A to generate the "Custom View"
To show data from multiple lists, you can use Content Query webpart. For reference:
Or you can create a DataView to show data from multiple list. For reference: