Create row in table

[#1]

Hi,

I have the following table:

Month	Ward Cleanliness	Toilet   Cleanliness
Apr-15	93.0	87.7
May-15	93.4	88.9
Jun-15	93.5	87.7

I want to insert a line to show the Target for each question, as below:

Month	Ward Cleanliness	Toilet   Cleanliness
TARGET	90.7	93.7
Apr-15	93.0	87.7
May-15	93.4	88.9
Jun-15	93.5	87.7
Jul-15	92.8	88.1

How could I do this?

Thank you inadvance

[miguelbraga]

Can you share a qvw sample so that we can work on? If not, I'll work on getting your desired results

[Anonymous]

Do you have a data source that contains the Targets for each question ?

If so the than load that data in your script.

If not then you may have to create something like a spreadsheet, type the Targets into that and then load them from there.

[miguelbraga]

Here you go, please see the attached file and the excel file .

Hope you the best weekend.

Regards,

MB

[#5]

Perfect, thanks