2 Replies Latest reply on Oct 1, 2018 10:07 PM by Jonathan Brough

    Formula to count number of stores per city

    Alexander Farr

      Hello everybody,

      I have a set of data which shows the revenues that each store made. I want to sort the revenues by city. At the label I would like to show the number of stores per city. For this I used following formula:

       

      Count ([Store (CityCountyTable)])

      However, this yields following result:

       

      3.jpg

       

       

      When manually checking, the number of stores should be around 1 or two each.

      How do I need to change my formula to achieve the result I want to have?

       

      You can find the packaged workboook here: https://1drv.ms/u/s!AtNwspiFU1pNhK1SCU4Zqj-A1B3aIQ

      Thank you very much for your help!