Microsoft Dynamics Forums Homepage

Forum Home Forum Home > Microsoft Management Reporter and Microsoft FRx > Management Reporter
  New Posts New Posts RSS Feed - % of Sales Calculation for Parent Summary
  FAQ FAQ  Forum Search   Register Register  Login Login

% of Sales Calculation for Parent Summary

 Post Reply Post Reply
jomini_bt View Drop Down Member Member

Joined: September 21 2017
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote jomini_bt Quote  Post ReplyReply Direct Link To This Post Topic: % of Sales Calculation for Parent Summary
    Posted: September 21 2017 at 7:12am
I am using a fairly simple Reporting Tree where I have several stores rolling up into a summary.  All my hard numbers work fine.  However, My % of Sales is also rolling up rather than calculating off the summary.

For Example:
On the Summary Company I have Net Sales of:

Actual = 600,000
Plan = 800,000
Last Yr = 900,000

% of Net Sales is:
Actual: 619%
Plan: 640%
Last Year: 720%

What % of Net Sales should be is:
Actual: 103%
Plan: 107%
Last Year: 103%

How do I get that to Calculate for the column definition rather than Summarize?

Back to Top
Sponsored Links

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Copyright 2013 All rights reserved. is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com