We would like to see Gross Profit percentages (COGS/Revenue) for the three divisions of our company. I have been able to set this up in the row set, but in our period and YTD variance columns I do not want see the percentages. Is this possible?
I am fairly new to configuring reports so I apologize if this is a simple answer!
Best answer by bryanb39
View original
+5
The formatting may not be exactly as you want, but you can calculate a percentage by dividing columns and formatting as a percentage.
You need COGs and Revenue separated, so you would use the data source section to filter one column to only use COGS, the other to only use Revenue, then a visibility formula to hide those two columns. Then you can reference those two in a 3rd column to display your COGS / Revenue percentage.
I probably should have included this in my original post. I am looking to not have the highlighted percentages on the report.
+5
I edited my response, I had the rule backwards, the following should work:
In your row set set the Column Group to be AB1 for example for the ones you want to hide.
In your Column set, set your printing group to be AB1 on the non variance Columns.
Since the variance columns have no printing group set, it’ll just show rows with no Column Set.
No idea why the fields have different names, but Column Group is basically Printing Group.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.