I am trying to create a calculated dimension to store post info from existing grp
. In my data set I have monthly record for each ID. When in grp field it hits ‘null’ it should store value (after null record) in new field.
e.g for ID =1 ,jan /feb/march has grp value A , and in April/may it has null. And in june/july it has B .. so it should store “B” in postGroup (calculated dimension). But some how I am not getting desired output. Can somebody help.
I am trying create a new group INFO column for a person when I find a null value for a GRP field for him . if you take a close look at excel I sent ,
For ID = 1 ,jan /feb/march has grp value A , and in April/may it has null. And in june/july it has B .. so in new grp which in my case POSTGRP it should store “B” for the said recipient.
