Crosstable Expression

[cbaqir]

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:

[Anil_Babu_Samineni]

Look here?

Work around, May possible in script for 3rd expression then Use flag to exclude with in the Count statement

[sunny_talwar · Accepted solution]

May be this

If(Count(DOMAIN) = Before(Count(DOMAIN)) or Count(DOMAIN) = After(Count(DOMAIN)), Null(), Count(DOMAIN))

[cbaqir]

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?

[sunny_talwar]

Not the preceding row... it is looking in preceding column and proceeding column

[sunny_talwar]

Check out After/Before here:

Missing Manual - Before() and After()