Cross Table Show where one occurence

[cbaqir]

Right now, my chart based on the cross table shows every ORDER_VV where the dimensions are the same. I want to ONLY show items where there is only one occurrence at 1 ORDER_VV.

For example: The only item in this DESCRIPTION that only occurs at 1 ORDER_VV is the following so I would ONLY want to see it and the ORDER_VV of SMLB.

Something with conditional using getselectedcount maybe?

TIA!

[sunny_talwar · Accepted solution]

May be this

If(Count(TOTAL <DESCRIPTION, NOTE, ORDERABLE, ORDER_SENTENCE, PRECHECKED, DOMAIN> ORDER_VV) = 1, Count(ORDER_VV))

[cbaqir]

Thank you!