Merging two charts total

[NavinReddy]

Hello All,

i have two chart with the total information, for each number i have one expression.i need to calculate the total % on weekly basis. kindly help me 

Table1			Table2
Issue Names	Prior Week  Total		Issue Names	Current Week Total
A1	310		A1	316
A2	2		A2	8
A3	8		A3	6
A4	0		A4	-8
A5	316		A5	306
A6	344		A6	333

Expected Output

Issue Names	Prior Week	Current Week	WoW %  Change
A1	310	316	2%
A2	2	8	300%
A3	8	6	(25%)
A4	0	-8	0%
A5	316	306	(3%)
A6	344	333	(3%)

Now i need to merge these two charts to calculate the %,
could some one help me with the logic.

Thanks in Advance

Navin

[Lisa_P]

Create the output table, the other tables should be linked through the Issue Names field in the data model.

Simply create the first 3 columns as dimensions, then in the last column create the expression:

([Current Week Total]-[Prior Week Total])/[Prior Week Total] and label it as WoW %  Change, format the  result as an integer, Show in Percent

[NavinReddy]

@Lisa_P  thanks for your reply 

Im bit confused implement this logic, do you want me to create  output table in script side. Suggest me