Extract a Specific Number from a column

[luciam22]

Hello Community, 

I am trying to extract the number in red under the CPA column. I would like to have those metrics in a new table for each country. The tricky part is that I only want the CPA value for the subscription goal under the Audience group, included on the left side. What formula can I use to do this quickly?

Thank you,

Lucia

[#2]

Hi @luciam22 

In attached file, Table1 is the Source for the above Pivot Table. Table1 is also used by Power Query to "generate" the 1st 2 columns of the green table on the right. Column CPA has been added in Excel with a GETPIVOTDATA formula

Refresh the green query/table when adding/removing Account Names from your Data Source

[#3]

@luciam22  (@cuong) If even MSFTees don't provide feedback here...