Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only

  • 1.  How to access a table using report column?

    Posted 04/01/19 02:41 AM

    Hello,

    I am developing a report where I need to map 2 parameters of same entity. The entity has cost and entity type. Both parameters are in same table but in different columns. Can I use lookup to access there parameters using lookup function? Or is there any better way to do it?

     

    Below is an example : 

    Table:

    Entity    Cost       Type

    XYZ      100         NR

    XYZ        5           EN

     

    Report required:

    Entity    Cost       Type

    XYZ      100         EN

     

    My goal is to map cost from row 1 and type from row 2 for entity XYZ in the report. Entity being one of the column in the report. Please advise. Thank you!




    #TBMStudio


  • 2.  Re: How to access a table using report column?

    Posted 05/28/19 11:14 AM

    Were you able to figure it out?  If not, post a link to this question in a status update to drive more people to it.


    #TBMStudio


  • 3.  Re: How to access a table using report column?

    Posted 05/30/19 08:26 AM

    Yes I got the answer myself using simple look up function. Thank you!!!


    #TBMStudio


Related Content