Hello
I am using the below formula to source data a from a pivot:
=IFERROR(IF($C2="ROUTINE",GETPIVOTDATA("AllocatedNew",SLOTS!$B$52,"Date",B$6,"Years",B$5),IF($C2="URGENT",GETPIVOTDATA("AllocatedNew",SLOTS!$B$95,"Date",B$6,"Years",B$5),IF($C2="BOTH",GETPIVOTDATA("AllocatedNew",SLOTS!$B$126,"Date",B$6,"Years",B$5),IF($C2="ALL",GETPIVOTDATA("AllocatedNew",SLOTS!$B$6,"Date",B$6,"Years",B$5))))),"")
The beginning on the formula is looking at a drop down filter with 4 options:routine, urgent, both and All and it is bringing through the correct figures.
However, I have another filter where you can select a specialty and this datais available in the pivot, example:
<tbody>
</tbody>
I need the above formula to also look at the speciality dropdown filter but I am not sure where to put this code in the formula? The speciality drop down is found in cell A2
Does this make sense?
Any help appreciated
Katherine
I am using the below formula to source data a from a pivot:
=IFERROR(IF($C2="ROUTINE",GETPIVOTDATA("AllocatedNew",SLOTS!$B$52,"Date",B$6,"Years",B$5),IF($C2="URGENT",GETPIVOTDATA("AllocatedNew",SLOTS!$B$95,"Date",B$6,"Years",B$5),IF($C2="BOTH",GETPIVOTDATA("AllocatedNew",SLOTS!$B$126,"Date",B$6,"Years",B$5),IF($C2="ALL",GETPIVOTDATA("AllocatedNew",SLOTS!$B$6,"Date",B$6,"Years",B$5))))),"")
The beginning on the formula is looking at a drop down filter with 4 options:routine, urgent, both and All and it is bringing through the correct figures.
However, I have another filter where you can select a specialty and this datais available in the pivot, example:
Sum of AllocatedNew | Years | Date | ||
2018 | 2018 | 2018 | 2018 | |
SpecFinal | Apr | May | Jun | Jul |
ANAE | 123 | 456 | 789 | 123 |
BREAST | 123 | 456 | 789 | 123 |
CARD | 123 | 456 | 789 | 123 |
I need the above formula to also look at the speciality dropdown filter but I am not sure where to put this code in the formula? The speciality drop down is found in cell A2
Does this make sense?
Any help appreciated
Katherine