2 Replies Latest reply on Jul 28, 2016 5:42 AM by Abhi Agarwal

    Counting the number of sites in a multi-site business

    Abhi Agarwal

      I am preparing a multi-site business database. In each year some new sites open and a few sites close. But I am not able to get the correct count of sites in each year.


      I thought of creating a calculated count of number of sites for each financial year separately but that would not serve the purpose.


      In the actual version there are 3 tabs:



      Tab 1. Financial data: The P&L Lines have the full P&L and all different accounts such as Sales, costs are in different rows

      Tab 2: P&L Mapping

      Tab 3: Site database. This has 1 site on each row and has description of each site e.g. location, segment etc.


      Desired result


      Ideal result



      I have included the excel file and tableu example. If someone can help me I will really appreciate it.