The function GETPIVOTDATA can be used with formulas in Calc. Use this function if you want to reuse the results from the DataPilot somewhere else in your spreadsheet.