Hi @Nick_Mainella,
I just posted a guide on how to workaround some of the current limitations of the pivot table widget which I think could prove useful to you, if you haven’t found a different solution yet.
While not a direct solution, it should be an easy one to adapt from the one covered in this guide.
Best,