Hi All This is my first time posting so please excuse me if i have missed anything. I use enterprise guide and i have a data set that looks like this below. With thousands of IDs. I want to add an extra variable(ENTRIES) that sums the number of times the ID entered over time. the dates go back many year and will continue going forwards. Any help will be appreciated. Thanks KKS2 ID Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Entries 1111 . . 1 1 1 . 1 (entered in Sept17) 1112 1 . 1 1 . 1 3 (entered in July17 then Sept17 and then dec17) 1113 . . . . 1 1 1 (entered in Nov17) 1114 . 1 1 1 1 1 1 (entered in Aug17) 1115 1 . 1 1 1 1 2 1116 1 . 1 . . . 2 1117 1 . . . 1 . 2 1118 1 . . 1 . 2 1119 . 1 . 1 1 . 2 1120 1 . 1 1 . 1 3 1121 . 1 1 . . . 1
... View more