2 Replies Latest reply on Sep 7, 2016 2:13 AM by anil kumar

    Count of customers Bins by Region

    anil kumar

      Hi all,

            I am trying to bin products by customers, I have achieved by using

      LOD calculations ({ FIXED [Customer ID] : COUNTD([Product Name])}) by Region wise.

      The issue is if am filtering a single region using as context then the values are coming up accurately,

      but when I am using all regions the values are coming up wrong.

      B 1.JPG

      B 2.JPG

      Attached workbook please look into it.

       

      Thank You