Need help on pulling data from Pivot Table

[spycein]

Hi Everyone,

I have created a pivot table from two different tables using power query.

Now i am looking for a look up formula which can get the data from the pivot table.

Please find attached the picture of my Pivot Table for your reference.

The formula looks like this: =GETPIVOTDATA("[Measures].[Sum of TRADITIONAL BUDGET]",$A$5,"[OPS_Master].[Report Group]","[OPS_Master].[Report Group].&[Payroll - salaries and wages]")

Thanks

Shib

[/URL][/IMG]

 

[edwin1682006]

assuming:
Row Labels = Column A
Traditional Budget = Column B
IBB = Column C

use =vlookup("Payroll - salaries and wages", Column A:A,2,false)+vlookup("Payroll - salaries and wages", Column A:A,3,false)