I want to do some basic math and put it in my report. I created the formula and got to it work but I only want that field to be visible in a certain area and hide it in all the other places.
Michael or James if you are out there....... I want to do some calculations to my Group 1 but I only want it to show in that particular section. For instance I want to calculate my total sales and show that under INCOME but I don't want this to show under COST OF GOODS SOLD, SELLING EXPENSES, OTHER INCOME, etc. I will then have a different calculation for each of those individually.
Again, I'm trying to make this report similar to the Excel version I will attach.