| Unique Cross tab requirement [message #1794536] |
Sat, 01 September 2018 07:30 |
Eclipse User |
|
|
|
Trying to simplify the requirement as much as possible
Data contains
Name----Source----DateA-----DateB----------A----B
N1-------S1-------Jan18--------Mar18---------1----1
N2-------S1-------Jan18----------------------1----0
N3-------S1-------Feb18-------Mar18----------1----1
N4-------S1-------Mar18----------------------1----0
N5-------S2-------Mar18-------Mar18----------1----1
* Actually column A , B dont exist but are derived from DateA and DateB - for simplicity
Need to show report as
Source ----Jan18-------Feb18------Mar18
----------------A B -------A B-------A B
S1-------------2 0--------1 0 ----1 2
S2 ------------0 0 -------0 0 ----1 1
Basically each row can have 2 dates and need to show the SUM of A & B monthwise. B is dependent on Date B and A is dependent on Date A
Not able to decide how to achieve this in Birt Cross Tab
Has anybody achieved this ?
|
|
|
Powered by
FUDForum. Page generated in 0.84101 seconds
Home