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!
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!
If you've found this thread useful, dive deeper into User Group community content by role