re: Joining multiple visual report table to calculate the sum
Hello Community, I have multiple tables giving information like business unit code, payer type, region. The objective is to calculate the estimate revenue coming from each unit by different payer. So from table we are calculating average per day revenue from each payer "Insurance" at specific Business unit "SN000". We have taken total SUM of the revenue and divided by total day categorizing average pay based on Business unit code and payer type. From another sheet. we have service. we are pulling data like service date and number of patient served on that day. Which is also categorize by Business Unit and Payer type. I had to create seprate table because when I'm trying to put all this information in average rate estimation it will create total patient number instead of giving result like one above telling number of patient on specific date, BU, and payer. We are trying to multiply Number of patient * Average pay to calculate total for each to calculate rough cash inflow from different unit. How can I multiply two seprate design by using table visualition to calculate each day revenue based on different categories. Final objective is to get something like this Is their away I can do setup this table like the above one ? id there anyway we can automize the above report to gather this census number everyday for particuliar day and calculate the total of that days and for all days days combine
