Calculating running totals and filters -
07-05-2004
, 05:17 AM
It is possible to calculate running totals with Sum(PeriodsToDate(...)). I use Excel as client of MS AS. If no filters, the results of expression above is correct. But if in Excel I filter some dimensions, the result become invalid - because it also take into account all rows, not only rows which satisy filer condition. Is it possible to calculate running totals only for rows which satisfy filters? |