Forum Discussion

BInovice's avatar
BInovice
Frequent Visitor
4 years ago
Solved

Calculation between rows with same ID

All, my data are structured as below and I need to run the calculated values in the last column. Each ID contains exact same 4 attributes.  ID Attribute Value Cal=(A+C+D)/B ID1 A 6   ...
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    You can easily unpivot in the query editor. Select the Attribute column and under the Transform tab, choose Pivot column.

    Then Add Column > Custom Column

     

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

You can easily unpivot in the query editor. Select the Attribute column and under the Transform tab, choose Pivot column.

Then Add Column > Custom Column

 

BInovice's avatar
BInovice
Frequent Visitor
4 years ago

Thank you AlexisOlson . The solution works magic