Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a crosstable where my requirement is to only show discrepancies (differences) in the chart. The duplicate can be on any of the dimensions after DESCRIPTION.
For example: since the ORDERABLE here is the same in both ECISA and CAREB for this DESCRIPTION, I would not want to show it on this chart:
May be this
If(Count(DOMAIN) = Before(Count(DOMAIN)) or Count(DOMAIN) = After(Count(DOMAIN)), Null(), Count(DOMAIN))
Look here?
Work around, May possible in script for 3rd expression then Use flag to exclude with in the Count statement
May be this
If(Count(DOMAIN) = Before(Count(DOMAIN)) or Count(DOMAIN) = After(Count(DOMAIN)), Null(), Count(DOMAIN))
I wish I could have thought of this... but is it just looking at the preceding row? What if it's not exactly in that order?
Not the preceding row... it is looking in preceding column and proceeding column
Check out After/Before here: