Appending Rows to existing table

[Shiva123]

hello,

           everyone  i am trying to append a dummy row to the existing straight table, that dummy row has a dollar amount which is the only expression.  The dummy row is from another source table, where as straight table data source is from  another table . is that possible to add a dummy  row  to the table .

thanks

Shiva

[vishsaggi]

Can you show us what your expected output is?

[Shiva123]

attached  is the app,  below main  straight table, there is another table which has to be added to the straight table below the totals line .

the main link for this is PAL 3 that is the common thing. we are appending because to show the difference in dollars with rebates and without  rebates . i have tried, but they come as columns only but not as rows

thanks in advance

Shiva

[vishsaggi]

I will look into this tomorrow.

[Shiva123]

any idea vishsaggi‌

[Shiva123]

do u have any  idea about this  stalwar1‌

[vishsaggi]

Sorry for delay in replying was pretty occupied. So what could be your dimension values in that first row for your Net Dollar value. IN your straight table i mean?

[Shiva123]

the dimension value stays the same , it can be blank or dummy value can be added . the new row should be  below

the  total value of net amount .

thank you again

[vishsaggi]

The only way i think is using Pick(Dim()) . Create an inline Dim table like

Dim:

LOAD * INLINE [

Dim

1

2

3

4

5

];

After you run your file with this just upload again so we can try.

[Shiva123]

there is already inline in the script with dimension in the last tab .

thanks

Shiva