Found a resolution to this issue.
I needed to assign a proper partition on the columns we are using in the vis in the calculation. {Column_selected_for_pivot} will need the curly brackets but this is your column that you are selecting and aggregating from in the UI.
Revenue Base:
ifelse({display_name} = ‘Revenue’, {Amt Usd (copy)}, 0)
tot_rev_agg:
sumOver(sum({Revenue Base}), [{Column_selected_for_pivot}], POST_AGG_FILTER)
var % final:
sum({Amt Usd (copy)}) / tot_rev_agg