4. Develop an aging analysis by customer and invoice using 30-day increments (0-30 days, 31-60 days, 61-90 days and > 90 days). Display this at the customer level with the ability to drill down to the transaction (invoice) level. Provide a visualization of the percentage of accounts receivable in each aging category at the company level using a column chart (with percentage as the x-axis and aging category as the y-axis). (aging is the difference between the period end and the invoice date) the period end is 12/31/15.

I've already done the excel formula to find the dates between the invoice date and the period end date. I have a formula, if then, to put them into those 4 groups. I think I am just confused on how to format the pivot table and the graph. What info do i need?

I found two solutions on here, but i cannot figure out how to get the solution. Please help.

I believe that 0-30 is . 31-60 is 33.60%. 61-90 is 9.12%. >90 is 2.06%. Where are these values coming fromjQuery22409639373130871485_1592008824900 How to I get there??