How to apply custom formatting like "%" and "$" to the values in the pivot table based on the column name

[Xclipse]

Hi @tnmatta, I am marking this reply as, “Solution,” in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - Quick Sight Arena)