Forum Discussion
Get value from previous row
I have a data set where I want to find a value from a previous row based on the Hiearchy Level. I'm creating AREA and FIELD columns and want them to display the last AREA or FIELD in the Hierarchy...
Hi Angella ,
Is the information you are presenting in the order you have your data? do you want to add an addtional column?
I want to add two additional columns - AREA and FIELD which would populate for all CC entities. My problem is that the associated hierarchy is listed above each CC in the same column when I need it in separate columns. Hopefully that's clear. I only need CC's in my dataset, but I need the associated hierarchy.