Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculated or Virtual table based on 3 tables

Hi,

 

i have 3 Tables

 

 

Now i need to create a new table based on that

 

it should have as 1st column the date and all other column headers should be the value of location name. The values should be the count of case ids.

 The result should be look like that:

 

How can this been archived?

 

 

Thanks & Regards

 

 

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      hi,

       

      i did not want to have a visual. I need to create a table to calculate further calculations.

       

      p.s. i did already try to use a vaisual but the totals where not calculated right.

       

       

       

      Regards