Scenario: I have a list A with some items and list B with items linked to list A (for example number/currency values). Lists A and B have one to many relationship.
Problem: How to show combined values from the lists A and B
The only resolution I found that makes sense to me is import to Excel with PowerPivot and join lists there. Any other ideas?