4 Replies Latest reply on Feb 19, 2014 3:17 PM by SreeHari_p

    PI AF - Excel

    SreeHari_p

      Hello Guys,

       

      Just wondering, if there is something in excel/pidatalink similar to Element Relative Display in Process Book. What i want to achieve, a tree view listing elements on left side of my excel sheet, upon selecting any element, get the attribute (averages, totals etc.. via pidatalink functions) to the sheet. any ideas !! we may call it Element Relative Excel Report 

       

       

       

      1732.Capture_5F00_AF_5F00_excel.PNG

       

       

       

      1830.Capture_5F00_AF_5F00_Excel_5F00_.PNG

        • Re: PI AF - Excel
          Roger Palmen

          I'd recommend to get all the data you need using DataLink's capabilities to get data from AF, or to use an OLEDB Enterprise Query. Then present the data using a PivotTable, so that the data can be accessed in the way you describe, using the built-in filtering, grouping, and sorting capabilities of the Excel PivotTables.