Forum Discussion
summarize two tables
thanks for your answer. "maxx(filter('table1...." almost worked!
I get the newspaper column, but it only shows for one streetname one newspaper company.
But it has to show the streetname several times, in order to show all the newspaper companies.
| streetname A | newspaper company A |
| streetname A | newspaper company B |
| streetname A | newspaper company C |
Anonymous Thanks for your answer, "related" does not work. error message reads, that there is no connection in this context. (I made a connection with date), I also tried "lookupvalue" before, but error shows multiple values where single value expected
Super UserAnonymous ,
I need to try with data.Can you share sample data and sample output.
mark me @
Appreciate your Kudos.
Thank you!
I uploaded some sample data.
- Ashish_Mathur
Hi,
Please show the expected result very clearly.
Hi,
I try to explain it in more detail.
I have actually three tables. 1) Newspaper distribution area, 2) customer info (address) , 3) newspaper distribution costs
I want to compare these tables to get the following results.
So, I thought to summarize them in one table is the easiest way.
I want to know:
1) How many customers are coming from areas with no newspaper distribution.
2) How many areas with newspaper distribution, but no customers
3) How much is the cost for each area, each newspaper, each distribution agency, cost per customer
customer ID City Ward Newspaper/Agency count all customers count areas with no customers count of customers with no distribution Tokyo Shinjuku 9 Agency A 1 zzz Tokyo Shinjuku 7 Agency C 1 xxx Tokyo Shinjuku 10 Agency B 1 yyy Tokyo Shinjuku 11 1 1
