Is there a way to have a value be frozen and operate independently of the column? Example attached…the highlighted column would stay static.
You can use the settings on a table card under General > Number of Locked Columns to specify the number of columns on the left you want to freeze.
Thanks @GrantSmith Is that option just for Mega Tables? I don't see it on Pivot Tables
I believe you need to move your Leads field out of values and into rows and then aggregate it the same way you had in in values.
@MarkSnodgrass I keep getting the "An issue has occurred during processing. We are unable to complete the request at this time." when I do that.