First time post!
Hi
Does the getpivotdata formula only work with 1 column label and 1 row label? The formula below is used with a pivot table that is returning the result into the below report. The pivot contains the data but is not returning the CT/MRI and Outpatient results.
=IFERROR(GETPIVOTDATA("local tariff price",Pivots!$AY$5,"MOD",A4,"area",$A$1,"for income statement only",B4),0)
Hi
Does the getpivotdata formula only work with 1 column label and 1 row label? The formula below is used with a pivot table that is returning the result into the below report. The pivot contains the data but is not returning the CT/MRI and Outpatient results.
Sum of Local Tariff Price | For Income statement only | ||||
AREA | MOD | Admissions | CT/MRI | Outpatient | Grand Total |
Area1 | April | 12287.06 | 2362 | 14649.06 | |
Area2 | April | 13482.64 | 2353 | 15835.64 | |
Area3 | April | 14324.54 | 514 | 216.42 | 15054.96 |
=IFERROR(GETPIVOTDATA("local tariff price",Pivots!$AY$5,"MOD",A4,"area",$A$1,"for income statement only",B4),0)
Category | Cost | |
Admissions | | £13,482.64 |
CT/MRI | | £0.00 |
Outpatient | | £0.00 |