ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

Brain Teaser: Aggregate by Dimension Attribute

10/8/2016

0 Comments

 
Picture
Calling all Jet Reports report writers.


I saw this post on Dynamics User Group from a few years ago.
"I need help creating a report in Jet Express [report writing software]. I have the "Age" field in the vendor table and I want to show purchases grouped by age bucket: ex. 10 - 20, 20 - 30 , 30 - 40 and the count of vendors .. need help"

Solution Permutations: 
  • Lvl 1 Solution:  Assume using Jet Express & all data originates from Vendor and Vendor Ledger Entry.  May have to 'mangle' the data post execution.
  • Lvl 2 Solution:  Assume using Jet Professional & all data originates from Vendor and Vendor Ledger Entry.  Can use Pivot tables or other post aggregation methods, but no mangling data post execution.
  • Lvl 3 Solution:  Build solution without using Table Builder and no pivot tables (or similar) for aggregating the data post running the report.

Don't miss the solution!  Sign up for our bi-monthly mailing list or visit www.OnyxReporting.com/blog to access our archived posts.

Jae Wilson is a Jet Reports Certified Trainer from Data Analytics consultancy Onyx Reporting.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters