josephhung
New Member
- Joined
- Jul 7, 2021
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hello Community,
I'm trying to create a calculated field in a pivot table and there is one formula as below.
This formula works fine in my original excel sheet, but I can't create one in pivot table as a formula. Is it because of the 'match', 'offset' or 'column' functions that prevent me from doing so?
=MATCH(O4,SUBTOTAL(9,OFFSET(Y4,,,,COLUMN(Y4:AK4)-COLUMN(Y4)+1)))
Thanks a lot.
I'm trying to create a calculated field in a pivot table and there is one formula as below.
This formula works fine in my original excel sheet, but I can't create one in pivot table as a formula. Is it because of the 'match', 'offset' or 'column' functions that prevent me from doing so?
=MATCH(O4,SUBTOTAL(9,OFFSET(Y4,,,,COLUMN(Y4:AK4)-COLUMN(Y4)+1)))
Thanks a lot.