7 Replies Latest reply: May 16, 2015 4:51 AM by Piet Hein van der Stigchel RSS

    How do I reference two different states within the same expression?

      I work for an eCommerce company and we are trying to clean up our product categories by seeing how many skus overlap between them.

       

      To do this, I created a table with: (inherited state)

      CategoryID

      CategoryName

      COUNT(DISTINCT(SkuID) as Sku Count

       

      Then an associated categories table: (alternate state)

      CategoryName

      Count(DISTINCT{<SkuID = p({$} SkuID)>} SkuID) as Skus In Common

       

       

      My next step is trying to see the proportion of Skus in Common compared to the original Sku Count from the first table, but I can't manage to make it work.

       

      Any suggestions?

      My alternate stats is called {AssociatedCategories}.