This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need to automate a current copy/paste Excel process, the end product of which is an Excel report that is pasted into an email. The structure is basically a crosstab with categories down the side, aging buckets across the top (Total, 0-30, 31-60, 61-90 and so on) and claim counts as the data points. The only wrinkle is there are also percentages as data points. So for example if at the intersection of CategoryA and bucket 0-30 the claim count is 100, this count is also represented as a % of the whole of the category total. So something like:
0-30 31-60 Totals
Category # / % # / % # / %
1 100/10% 200/20% 1000/10%
This output needs to be put in the body of an email. Is this possible? If so, how?