I have a pivot table with a row field ("name") that has the names of some elements of the periodic table. There are three value fields - the first a count of the occurence of another field "sap_batch" and the other two the average/std dev of a "RESULT" field.
I have another table ("CLTBL1"), a list object, on the page that has several fields. One of them is called "analyte" and another called "CLASS". The "analyte" field in CLTBL1 is identical in terms of contents to the "name" field in the pivot table.
I am trying to use the LOOKUPVALUE function to get the contents of the "CLASS" field from CLTBL1 into the pivot table based on the value in the "name" field. Here is the syntax I'm using: