Getting dates in one row

Hi All,

I am working on the data visualizer and have the data as below

The columns order,model, ord date, rec date,cur prm come from the DOMO workbench while the columns prm date -7D, prm date -14 D, prm date -28 D come from the beast mode...

I am trying to get the above data in the format below...Can you please help here..


Attached the data


Answers

  • ozarkram
    ozarkram ⚪️

    @kdeike ..Thank you so much!...Really appreciate your help!