Row Subtotal & Total Aggregation in Lieu of Column Expression
Hi all! I'm new here, and I'm hoping that someone has encountered the issue that I'm having. I have a report that I am building that will attribute gross margin impact to individual sales channels and products. I am breaking the types of margin impact between, price, cost, sales mix, and other. I have chosen to build the price calc first, which uses several other columns already on my report. I have successfully created the formula, which produces desired result at the bottom/children levels. However, my report has a total and several subtotals rows that are also calculating, but are completely wrong. This is expected, because the calc is only applicable at the input/child level. Rather, I want the total and subtotal rows in this columns aggregate the input level rows under them. How do I keep using the formula on the input level rows, but have the subtotals and total rows summarize the results of the input rows?