how to add columns from two datasets

giridhar

Hi all,

My name is giridhar.I have a doubt,plz clarify me.

i have two data sets.in one dataset i have columns like sale1,bill1,discount1.

and in second dataset, ihave columns like sale2,bill2,discount2.

i have to add and display the columns in two different datasets.

how can i add the columns from two datasets.
i have to show this in a grid like

DATASET1 DATASET2 TOTAL
sale1 sale2 totalsale(sale1+sale2)
bill1 bill2 totalbill(bill1+bill2)

how can i achieve this.please help me.

Jenkinsj5

You have two source data sets, next step is to create a joined data set.

?Right click on "Data Set" in the outline, and select "New Joint Data Set"

After the two data sets are joined you can create computed column, or work with it is the source for a new table.