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)



      COUNT(DISTINCT(SkuID) as Sku Count


      Then an associated categories table: (alternate state)


      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}.