mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Reports
  • Margin Calculations within Pivot Tables
Back to Manual

Margin Calculations within Pivot Tables

Pivot Tables offer increased runtime functionality for end-users without requiring heavy customization by developers. While Pivot Tables are easy to use, one common question received is “How can I add runtime calculations to my subtotal and grand total levels?”

To do so, begin by creating your Pivot Table as normal, being sure to select as many sequence keys and record selections as needed. Below is a sample Pivot Table:

In the example above, we want to see what percent of total sales was spent on cost of goods sold. To accomplish this, navigate to calculations and add a new calculation, as shown below:

What is important to note is that the Calc Type is set to “Application”. Selecting application as the type within Pivot Tables will create a margin calculation automatically at runtime. After adding this calculation, be sure to compile/recompile. Now, at runtime, the margin calc can be selected and displayed, just like all other non-sequence key, displayed numeric fields:

Created: August 20, 2012 | Modified: June 12, 2017

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Excel Freemarker Popular Java Reports Video App Properties Administration Retrievals Application Properties Data Dictionary DB2 Build Process Bar Graphs mrc-Productivity Series Email Compiling Graph Properties Maintainers Record Selections Parameters External Objects Tomcat Advanced Security Dates Database Dropdowns m-Painter Maintainer Calculations Admin Production Prompt Screens Bootstrap Templates SQL Form Validation Retrieval Performance Graphing Summaries Report Getting Started RPG Graphs

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Policy Cookie Policy Notice at Collection California Consumer Privacy Act (CCPA) Opt-Out IconYour Privacy Choices
mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2023 mrc. All rights reserved.