Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community Forums
-
Unique Cross tab requirement
https://www.eclipse.org/forums/index.php/mv/msg/1094951/1794536/#msg_1794536
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 ?]]>
Viral Shah
2018-09-01T11:30:31-00:00