dbTalk Databases Forums  

Calculating running totals and filters

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Calculating running totals and filters in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
andsm
 
Posts: n/a

Default 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?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.