2 Replies Latest reply on Apr 26, 2018 2:24 PM by Robin Fay

    lod with year?

    Robin Fay

      I'm trying to show a count of skus by store, or store count by item

      attached is an example

      I would like to have a calculation for 2017 store count and 2018 store count without using year in my view


      any ideas?


      I would think I could just do something like this

      if year(snap shotdate) = 2017 then { FIXED [Store]: COUNTD([Sku])} end   

      but that doesn't work at all.