- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Quickbooks Advanced Reporting HELP!!
I'm not sure where to start....I am trying to create a Customer Sales Activity Report in QuickBooks Advanced Reporting. Have no idea what I'm doing really and trying to learn on my own is proving very challenging! I've managed to get some data into my table but need help getting YTD columns and a 13-week average section on each customers sales. I would greatly appreciate any help on this issue!
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Are you looking for Quickbooks community? This is Qlikview community. May be you want to visit here:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apparently the QuickBooks advanced reporting is powered or made by Qlikview, so the dimensions, expressions, etc. are similar. That is why I ask here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you look into this may be will give some insights in creating such fields.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jessica,
Without specific knowledge of the QBAR Data Model I can not give you a precise answer but hopefully this can help you out.
First, check out QuickBooks Advanced Reporting
There are a number of training and tutorial modules.
As referenced by others, you need to look for a field that references a time period flag such as YTD or something similar. This field can be used inside a syntax structure called set analysis. This structure would look something like this: sum({$<YTD={1}>} TransactionAmount)
You would need to substitute the correct field name and value, then use the correct field for the qmount you are trying to sum.
Does intuit not have a help desk?
Regards,
Jeff
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Intuit will not help with Advanced Reporting, they make you find a "ProAdvisor". In the QuickBooks manual it specifically suggests the Qlikview community for help understanding "syntax" etc. I tried SO many QuickBooks tutorials, but it seemed I just had to find the right field name and finally did!