Combine two fields count non-null values in Straight Tables

[karan_kn]

Combine two fields and count only non null value. Please refer sample screenshot for better understanding.

T1:

LOAD * INLINE [

    AAA, BBB

    1, 567

    2, 568

    2, 569

    3, 570

    3, 571

    4, 572

    5, 573

    , 574

    , 575

];

[sunny_talwar]

May be just this.... Count(AAA)

[sunny_talwar · Accepted solution]

or Count({<AAA = {"*"}>}BBB)

[karan_kn]

Thanks Sunny