Help! Formula column behavior in column grouping
We have some reports where the design is best met via using Grouped columns and rows. Some grouped rows have their own formula row.
When returning data, for formula rows based on a data row, the result is correct. But a formula column based on data column that groups one or more dimensions is not correct. See screens below for clarity.
Grouping columns with data and formulas should return the result in a similar manner to grouped rows with data and formulas.
Version (include the version you are using, if applicable):
Screen labels from top to bottom: