I have 2 tables
- sales_overview
- sales_category
Now: I want to have a sum of all sales planning from sales_overview per category as a sum in sales_category.
How can I do that?
=[tablename].sales_overview.filter(depends on your categories).sum()
would be super helpful when you just post a picture
ok, thanks - let me check
I want to have the sum of all Betrag (Amount) where the Soll (Category) is the same as in this line
btw: this formula above does not work 
Betrag= Amount
Soll=Category
could u give me access to the sheet?
unfortunately not, it includes all details from our books of the company 
Hi Alex, just made a new doc and shared with you
Idea: want to have the current sum for each category A, B, C either in the detail or in the overview table
thanks for your support.
Thomas
Hi Thomas,
I did not get an invite, so i ll try to do it from “the distance”.
From what I gathered from your information, your formula will look like this:
[2017].Filter(Soll=thisRow.Category).Betrag.sum()
[table header].Filter(row to filter=thisRow.column in this table where the category name is).colum where you want the sum from.sum()
hope that helps 
I also adapted one of my tables slightly to give an example
Thanks for that, the formula works within the same table, I used
[2017].Filter(Soll=thisRow.Soll).Betrag.sum()-[2017].Filter(Haben=thisRow.Soll).Betrag.sum() as I need the +/- of the 2 colums
But: connecting with another table, this formula does not work:
the editor always deletes the thisRow.Bezeichnung to Bezeichnung
How does the colum Soll Saldo needs to be formatted?
by now I have, or do I need to have a lookup to my details table?
Grützi Thomas,
does it change the expression thisRow.Bezeichnung to Bezeichnung when you press enter, or while you are still entering the formula?
With my table, I can’t reproduce what you are describing. The part “thisRow.Bezeichnung” is not suggested when entering the formula, but after pressing enter it works for me…
The formatting is “text” for “Bezeichnung” (which is also the display column, same as for you) and Soll is formated as currency.
If you want to, I can give you access to the example I posted above