Displaying monthly membership amounts against NRR status

Hi All,

I hope that this isn't just my December brain, but I'm struggling to make this work! I've been asked to create a dashboard that shows the income of a selected date range for membership levels, and the New/Renew/Reinstate status of that constituent's contribution.

In the contributions cube, I'm using the contribution type to separate Pledge and Gift amounts, and the Pledge amounts appear to only show income from people who started their membership in that time frame. Is there a way to display all the pledged income that is received during that time frame whilst also indicating the NRR status and Membership level of the constituent it relates to?

Apologies if this is really simple, and thanks in advance!

Josh