It worked Thanks. I was wondering though if its different numbers other than 0's and 1's, how to do calculations?
Also shanks for sharing your Blog Link ,it has lot of useful info.
Thanks for replying,
Apple has a count of 2 for 1's and 1 for 0 for the month of OCT-2015 and no values for ALCATEL LUCENT for Oct.
Yahoo Inc has Eight 1's and two 0's
I am filtering by fiscal month Oct for simplification of testing.
If you are looking for something besides a 1, say a "2", you could do some logic inside the SUM.
Something like this:
SUM(IF [Case Time P1 8Hrs] = 2 THEN 1 END)