8 Replies Latest reply on Dec 3, 2018 7:37 PM by Zhouyi Zhang

    Counting active store by dynamic date filter

    Ho Yeung Lee

      Further Question:

      I try to use my real data set to do the counting. However, It doesn't work if i add the "Brand" and "Shop Type" filter.

      I would like to search the active and closed store under specific shop type and brand of product.

      Any idea?


      ------------------Below solved-----------------------

      I am trying to calculate

      1.the number of active location that currently have sales

      2.the number of closed location that had sales before but no sales in current month

      The number should be change by my date range filter.

      Any idea how can i calculate these numbers?