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.
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?