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:





      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!