Hi,

is there any way that we can interchange the rows at run time.Here is what my ask

 

Field1   Field2   Sales
Feb Wk1  Feb Wk1    $10
Feb Wk2  Mar Wk1    $20
Mar Wk1  Apr Wk2    $30 

as per the above dataset the field2 is the required resultset needed. so, if u see For Feb Wk1 the sales is correct, for FebWk2 the mapping column is field2 that has the value "Mar wk1" so the sales should show as $30. Below is the output am looking for

  


Field1   Field2   Sales
Feb Wk1  Feb Wk1    $10
Feb Wk2  Mar Wk1    $30
Mar Wk1  Apr Wk2    $40 
Apr Wk2  May wk1    $40

let me know how can we interchange the rows as per the field2 data mapping

Thanks!

This message has been edited. Last edited by: <Kathryn Henning>,

Hi subbu,

Please open a case on InfoResponse Online so that we can review your code and see how your data is described.

Thanks and regards,

Kathryn