Topic
No replies
SystemAdmin
SystemAdmin
15496 Posts
ACCEPTED ANSWER

Pinned topic week to week comparison in cognos

‏2012-12-05T11:52:32Z |
I have a requirement that require a week to week comparison. Could you help me on how to achieve the below sample in Cognos. Thanks!

Date------client_count---Weektoweek-------Formula
1-Nov-12_________2
2-Nov-12_________4
3-Nov-12_________5
4-Nov-12_________6
5-Nov-12_________7
6-Nov-12_________9
7-Nov-12_________12________
8-Nov-12_________15________13_______nov 8 - nov 1
9-Nov-12_________1________-3________nov 9 - nov 2
10-Nov-12________4________-1________nov 10 - nov 3
11-Nov-12________1________-5________nov 11 - nov 4
12-Nov-12________6________-1________nov 12 - nov 5
13-Nov-12________7________-2________
14-Nov-12________5________-7________
15-Nov-12________18________3________
16-Nov-12________17________16_______
17-Nov-12________6_________2________
18-Nov-12________7_________6________
19-Nov-12________3________-3________
20-Nov-12________8_________1________
21-Nov-12________2________-3________
22-Nov-12________9________-9________
23-Nov-12________13_______-4________
24-Nov-12________5________-1________
25-Nov-12________22________15________
26-Nov-12________1________-2________
27-Nov-12________6________-2________
28-Nov-12________4_________2________
29-Nov-12________7________-2________
30-Nov-12________9________-4________