The output of the table is
Product Volume Value %Volume %Value Period
abc 12 1,354 45% %60 12 Jan2012 to 19 Jan2012
xyz 4 354 15% %10 12 Jan2012 to 19 Jan2012

How do i display this Value?

This is a weekly report that runs between date1 and date2 already predefined.

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

What's your source data? What fields are available in the masterfile?

The source data is picked up from a SQL Database.

The fields availabe are Product_Code, Count(Row_Num) as Volume, Count(Price) as Value.

Since this is a weekly report, we usually display the heading as " From 01/12/2014 to 01/19/2012"

We would like to insert a seperate column after Product, Volume and Value called Period to display the date range " From 01/12/2014 to 01/19/2012"

date1 and date2 can be used in a Dialog Manager command to form the text value you seek.
-SET &MY_TEXT = 'From ' | date1 | ' To ' date2;
You may have to manipulate date1 and date2 into Dialog Manager variables.
Your print statement can be
Print
Product_Code
.
.
.
&My_Text

HTH