In the original data source, I created a new calculated column (Insert > Calculated Column).
When I go to create a pivot table (Insert > Transformation), the new calculated column does not appear as a field I can select. How do I create a pivot table with this new calculated column that I added? Thanks!
This isn't doable. The reason is the calculated column is based off the data source and is re-calculated any time the data is refreshed, updated, etc at runtime... that means when the data is loaded from the source, the calculated column is created. Your transformation can't be based off this at runtime. What you can do, is insert a transformation and then create a calculated column after the transformation.