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
Author
Message
jomini_bt View Drop Down
MicrosoftDynamicsForums.com Member
MicrosoftDynamicsForums.com 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 microsoftdynamicsforums.com. All rights reserved. MicrosoftDynamicsForums.com is an independent non-Microsoft website.
Email: contact AT microsoftdynamicsforums DOT com