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

Page 1 of 1
3 posts
[HELP] How to get a report from a specific category?
User avatar
overkill22
New MMEX User

Posts: 10
Joined: Sun Jun 05, 2016 7:32 pm
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?
Last edited by overkill22 on Mon Aug 15, 2016 11:08 pm, edited 1 time in total.
Re: get a report from a specific category
User avatar
overkill22
New MMEX User

Posts: 10
Joined: Sun Jun 05, 2016 7:32 pm
no one can help me with this kind of report?
Re: [HELP] How to get a report from a specific category?

Nikolay
MMEX Developer

Posts: 2275
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Up...........
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 2 guests