I have all my data in the powerpivot window. pivot tables or anything else) on the same worksheet if needed). Convert the GETPIVOTDATA to CUBEVALUE. You can use it to practice adding, deleting, and changing conditional formatting on a variety of pivot table examples. =IF (GETPIVOTDATA ("SEAT AVAL",'ATRRS PIVOT'!$A$3,"MOS","13D1","FY","2009","QUARTER","Q1") Is Null, "0", GETPIVOTDATA ("SEAT AVAL",'ATRRS PIVOT'!$A$3,"MOS","13D1","FY","2009","QUARTER","Q1")) Bottom Line: Learn how to apply conditional formatting to pivot tables so that the formats are dynamically reapplied as the pivot table is changed, filtered, or updated. The second argument (pivot table) is a reference to any cell in an existing pivot table. Ask Question Asked 3 years, 2 months ago. [Item A], then your formula might be something like, =CubeValue("Power Pivot Data", "[Items]. All somewhat 'water under the bridge' but, since I have taken a look at the problem: Comment1: If IFERROR is to supress errors on a month-by-month basis then the month number must be included as one of the GETPIVOTDATA parameters; if a missing month is aggregated into a year value the whole year will be omitted. Data_field (required argument) â This is the worksheet information from which we intend to remove nonprintable characters. Quick ? =GETPIVOTDATA( 'May Table'!A1, "SICK " & S20). category by recruiter update accordingly. With the first argument data_field you define the value field you want to be returned. NB. I can think of several instances where the GETPIVOTDATA() function can be very useful. =GETPIVOTDATA( 'May Table'!A1, "SICK " & S20). The ISERROR Excel function is categorized under Information functions Functions List of the most important Excel functions for financial analysts. Visit the Learning Center. The ActualPrice is calculated as =IF (A2