Month to Month comparison in Metrics

[#1]

Hi

I am looking for an output something like below.

can you share some ideas how I can calculate the difference in % between the current month and the previous one. I want this comparision for all the months in the table

Attrb1	jan	feb		march
A	50	54	+4%	60	+6%
B	70	73	+3%	79	+6%
B	80	89	+9%	85	-4%

Thanks,

Kranti

[#2]

Hi ,

Try to have the Data in Excel as

Attrb1	jan	feb	march
A	50	54	60
B	70	73	79
B	80	89	85

Then try the below code

Tab:

CrossTable(Month,Sales)

LOAD  Attrb1,

     jan,

     feb,

     march

FROM

[....................................]

(biff, embedded labels, table is Sheet4$);

Tab1:

NoConcatenate

LOAD Attrb1, Month,if(Attrb1=Previous(Attrb1), if(Previous(Sales)<>Null() , Sales-Previous(Sales))) as Differece

Resident Tab;

DROP Table Tab;

Please reply me for the same .

Regards

//Yusuf

[#3]

Thanks for the reply Yusuf.

Probem is that compliance numbers are calculated using metrics in the report. so i have to be able to compare in the report.

I provided just 1 attr to give you an example. I want to add/remove more  attributes to compare month-month changes in the %

Kranti

[#4]

Hi ,

     Can you provide the Sample Data with more than one Attribute and

also provide the Least Epected output .

It can be done , just needed some more sample data with more than One Attribute and

the Desired Result Output.

Thanks

Yusuf