I have data summarizing income for each month on one pivot table and data summarizing expenses from another pivot table. I would like to create a field or table that can subtract income minus expenses for me in one table. It seems like it should be easy enough.
Subtract summary of two pivot tables
+17Hi @Jesse_Clark,
Welcome to Airtable Community ! :grinning_face_with_big_eyes:
If you can include screenshots of your table, we would be able to help you better.
One easy way would be to link both data to a Month Table, use Rollup fields then a formula to get the difference.
BR,
Mo
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.