Forum Discussion

luciam22's avatar
luciam22
Icon for Microsoft rankMicrosoft
Jul 18, 2022

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,

Lucia

 

excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jul 18, 2022

    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

Resources