Forum Discussion

mireles's avatar
mireles
New Contributor III
4 days ago
Solved

Cube View Column that contains aggregate of the last 12 months

Hi all, I'm trying to create a Cube View with a single column that aggregates data for the past 12 months, rather than showing each month separately. Instead of this: Month May 2024 Jun 2...
  • T_Kress's avatar
    4 days ago

    Have you tried the out-of-the-box V# member that does a trailing 12 month total for you?

    V#Trailing12MonthTotal is a dynamic view member calculation that does this already.