Holly, were you able to come up with a different approach? I too would like to create a report of all top priority issues for a Program Manager over multiple projects with different Project Owner but within the same Portfolio.
I've tried to adopt what you have in the exercise but I think my report is complicated by having 2 custom fields on the same line, and wanting one to be left aligned and the other right aligned. Attached is the output and code as currently coded.
Thank you Narayan! Your video on how to use Shared Columns was also extremely helpful. I've been trying to figure out how to format when i have two custom fields on one line (left and right alignment) and was told it wasn't a capability in Shared Columns. Any chance you've cracked that nut?