I have two tables in the qvw. One contains the start date and end date of the customers and using a formula I can find out how many were active on say 15th of the month.
In a separate table I have claims paid and I can create a summary by using Monthname(Treatment_Date).
However, I want the two outputs in the same table as I want to take averages.
In the excel I have attached the output from the two tables and on third sheet have shown the output which I want.