- last edited on
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:
=LOOKUPVALUE(CLTBL1[CLASS], CLTBL1[Analyte], name)
Am I missing something? For whatever reason, when I click the add button in the Insert Calculated Field window, the window simply highlights the portion of the formula that reads "CLTBL1[CLASS]".
My guess is there's a formatting issue, but I've followed every guide I could locate on the matter and I don't see issue with formatting.
Your help is much appreciated,
- B Latif
11-13-2018 04:29 AM
Hi @B Latif
Is your Pivot Table created with Power Pivot?
You can only use DAX when using a Pivot Table created using Power Pivot.
by Lucky7423 on May 30, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020
Posted in Microsoft Ignite The Tour 2019 on February 14, 2020