LinkedIn
Twitter
I have payment data that is collected where I can select multiple months if a tenant pays for multiple months at a time (see first image). I then have a table that splits up those payments into their individual months for a report that I need to create (see second image). The report looks like my third image where the pivot table makes it so I can show the names of the tenants and then the amount paid for each month. Each month will have it's own column and show the amount paid. I can't get the pivot table to actually show the amount paid.
Any ideas on how I can create a pdf report with the data looking like my third image? I don't know if it can just be done with the data in the second image and using formulas and stuff on the pdf template or if I need to split the data even further onto another table and then pull from that data in the template, or just something else entirely. There are times that data needs to be edited or deleted, so keep that in mind.
Bonus points for helping me figure out how to get totals for each month at the bottom of the pdf template.
Payment Data
Split Payment data
Pivot Data (Report Looks somewhat like this)
