3 Replies Latest reply on Jun 28, 2016 11:45 PM by Ashish Chaudhari

    LOD calc w EXCLUDE

    Steve Gesuale

      Hi,

       

      I think perhaps I don't understand how to use EXCLUDE but here is what I'm trying to do.

       

      Data is quarterly but I want the row totals to exclude any quarterly distinction within a country. For example, the "3" in the bottom row should be a 2. It's returning 3 b/c there are two separate quarterly entries for Nigeria, and the calc I'm using that tries to EXCLUDE Date is obviously not the right approach.

       

      Capture.JPG

      Can anyone advise on how to revise the calc so that it only returns the number of countries with a "1" entry regardless of the number of quarters, i.e., the 3 for the bottom row would be a 2?

       

      Thanks!

      Steve