Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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