I'm totally ignorant about SQL, is there any way to get a report from a specific category?
For example, I have 3 shops.
I have 4 different bank accounts.
I manage the 3 shops with all the 4 different accounts.
So, to know which shop is doing good and which one no, I set categories and subcategories.
shop1
revenue
costs
shop2
revenue
costs
shop3
revenue
costs
The only place where I see something similar is in the categories> last calendar month/last 30 days where I can see:
Code: Select all
CATEGORY AMOUNT TOTAL
shop1:revenue 10
shop1:costs -6
Category Total: 4
shop2:revenue 15
shop2:costs -13
Category Total: 1
shop3:revenue 25
shop3:costs -5
Category Total: 20
Where should I start?