Hi, I am trying to do a stock valuation cube , whereby I need to sum up quantities in a given period. My problem is that if you analyse the data as at a date, you are given the value for the date and not the value from day one. is there a particular option such as running totals in olap - I am using Bids 2008.
my email is pagius@isl.com.mt
Running totals in olap
-
- Community Contributor
- Posts: 126
- Joined: Sun Jun 29, 2008 9:33 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- Location: Karlsruhe
Re: Running totals in olap
for MonthToDate (MTD) you could use the following function:
Mtd(Member_Expression)
HTH,
Marcus
Mtd(Member_Expression)
HTH,
Marcus