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

Build and share your cool customized reports built w/ one sql, Chart.js and Lua (https://github.com/moneymanagerex/general-reports)
Post Reply
User avatar
overkill22
New MMEX User
Posts: 8
Joined: Mon Jun 06, 2016 1:32 am
Are you a spam bot?: No

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

Post 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?
Last edited by overkill22 on Tue Aug 16, 2016 5:08 am, edited 1 time in total.

User avatar
overkill22
New MMEX User
Posts: 8
Joined: Mon Jun 06, 2016 1:32 am
Are you a spam bot?: No

Re: get a report from a specific category

Post by overkill22 »

no one can help me with this kind of report?

Nikolay
MMEX Developer
Posts: 1298
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

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

Post by Nikolay »

Up...........

Post Reply