Hi, I have a current problem which hopefully someone with better expertise may be able to assist with. There are 2 difference datasets I have: 1. This is raw data by each insurance claim and I create a varaible from the date in that data to have a column for total claims by months in 2016 (cicra 500,000 rows of data) 2. A plan claim numbers which is just 12 lines with a number of claims planned to receive I want to be able to show in one data visualisation that when I sum up all the claims from Table 1, how they compare to what the plan exepcted in Table 2. So it will for example say Jan-16, Actual 5000, Plan 4,000 and I can then do a comparison for the business to say when we are over or below plan. Any advices on how I go about doing this? Many thanks in advance
... View more