Question
How to filter running total results and grand total using year and month parameters in cross-tab.
How to filter running total results and grand total using year and month parameters in cross-tab.
RUNNING_SUM(SUM([Sales]))6.Create a calculated field and name it Running Total Sales (Filtered).
IF FIRST() = 0 THEN WINDOW_SUM( IF LOOKUP(ATTR(DATEPART('year',[Order Date])),0) = DATEPART('year',[Year]) AND LOOKUP(ATTR(DATEPART('month',[Order Date])),0) = DATEPART('month',[Month]) THEN [Running Total Sales] END) END7.Right click Order Date and click Duplicate.
LOOKUP(ATTR(DATEPART('year',[Order Date])),0) = DATEPART('year',[Year]) AND LOOKUP(ATTR(DATEPART('month',[Order Date])),0) = DATEPART('month',[Month])18.Place Filter to Filters card and only check True.
Grand Totals and Subtotals Do Not Show Expected Numbers With Table Calculations