Open Forum

Expand all | Collapse all

Management Reporter Percentages

  • 1.  Management Reporter Percentages

    Posted 28 days ago

    I am trying to create a report that has different columns with 2018, 2019 & YTD actuals and after each column, have a percentage of revenue column (seen below). Is there a way to just have the Totals show, rather than each row showing the 0.0% percentage as well? Thank you!

    Current issue - Remove 0%?



    ------------------------------
    Emily Berlin
    Service Express
    ------------------------------
    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


  • 2.  RE: Management Reporter Percentages

    TOP CONTRIBUTOR
    Posted 27 days ago

    Hi Emily, one way commonly done is to go to the ROW and their is a field for Column Restrictions.(Column H) where you can define which columns you want to DISPLAY.  For example, let's say we have 5 columns: Column A DESC descriptions from row, Column B This Year $, Column C This Year % Rev, Column D Last Year $, and Column E Last Year % Rev.  On the rows you want to only show in the $ columns type B,D in the Column Restrictions field (Column H in ROW) to only display the $ columns and not the % Revenue.  This makes the row more limited to just this one column but the method to accomplish the request.  Feel free to email with any specific follow up questions or screen shots and glad to help further.  Happy Holidays and New year ALL!



    ------------------------------
    Derek Krebs
    Sr Consultant, MSX Group
    PROSPERO by MSX Group, www.msxgroup.com
    Derek.Krebs@msxgroup.com
    ------------------------------

    Digital Acceleration Binge Day January 28, 2021 | 11:00 AM to 2:00 PM EST


If you've found this thread useful, dive deeper into User Group community content by role