Hi MarvinP,
Thanks for your reply/review. I suppose I'm asking for something that doesn't make sense with this dataset. Like you said, there doesn't seem to be a correlation between days to pay and average invoice for a customer (the RSQ is less than 1%). I probably just need to apply the total revenue across a percentage breakdown for days to pay (e.g., 32% of the revenue is received in 0 days).
How did you create the grouping of a range of 10 in your pivot table rows? That seems to be a very useful feature.
Bookmarks