New answers tagged joined-view
Other option will be to use designer workflow. Add the columns you require in List A and whenever any item get added/updated in List B or List C, use a workflow to update the values in List A as per your requirement. For dynamic columns use calculated columns.
Top 50 recent answers are included