I have a table with Month and a YTD calculated item in the columns and five metrics in the rows. Four of the metrics are financial. The fifth is headcount.
As my YTD calculation applies across all metrics, my heads are adding up rather than showing the last value. Note that I changed the settings of my underlying heads metric to Last rather than Sum for time dimensions, but this didn’t make any difference.
My questions is, do calculated columns have to apply across all metrics in the table?