Extract a Specific Number from a column


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,



2 Replies

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

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