Surreyview
New Member
- Joined
- May 23, 2019
- Messages
- 15
Hello,
I wonder if anyone can help me. I had the formula working a few months ago and now it wont work.
I have a pivot table with lots of data: The Columns are a list of service types and rows of quarter/year.
I have a table below where I want to collate the data, so for example for Q1 2019, I want to know how many people are selling Service A.
Then for Q22019, Q3 2019 and so on.
I am using the following formula:
=GETPIVOTDATA("Account Name:",$A$37,"Service Type:","Service A","Estimated Date for business to commence:","Q1 2019")
but I am getting back: #REF ! what have I done wrong? It did used to work.
Thank you
I wonder if anyone can help me. I had the formula working a few months ago and now it wont work.
I have a pivot table with lots of data: The Columns are a list of service types and rows of quarter/year.
I have a table below where I want to collate the data, so for example for Q1 2019, I want to know how many people are selling Service A.
Then for Q22019, Q3 2019 and so on.
I am using the following formula:
=GETPIVOTDATA("Account Name:",$A$37,"Service Type:","Service A","Estimated Date for business to commence:","Q1 2019")
but I am getting back: #REF ! what have I done wrong? It did used to work.
Thank you
