Page 1 of 1

[HELP] How to get a report from a specific category?

Posted: Mon Jul 11, 2016 2:55 pm
by overkill22
HI guys,
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
I'd like to create a report for those categories where I can choose the date to analyse, and which main category/ categories.

Where should I start?

Re: get a report from a specific category

Posted: Tue Aug 16, 2016 5:06 am
by overkill22
no one can help me with this kind of report?

Re: [HELP] How to get a report from a specific category?

Posted: Thu Sep 01, 2016 3:01 pm
by Nikolay
Up...........