Hi,
I have a requirement to show the Ending Balance in Quarters and Full Year instead of rollup.
For eg; I upload ending balance for Apr-19 so the Q2-19 and FY-19 should show Apr-19 balances, next month when I load May-19 balances Q2-19 and FY-19 should show May-19 data instead of rollup. Please refer to the attachment to better understand what I want to show in totals.
Please Note, I already have all months balances for 2018 so the view should display mar-18 values in Q1-18, Jun-18 values in Q2, Sep-18 values in Q3 and Dec-18 values in both Q4 and FY-18.
How can I achieve this, any suggestions?
Thanks,
AJ
Ending Balance in Period Rollup
-
- Posts: 8
- Joined: Tue May 26, 2015 11:14 am
- OLAP Product: TM1, PAL
- Version: 9.5, 10.2.2, 2.0.1
- Excel Version: 2010 2013
Ending Balance in Period Rollup
- Attachments
-
- Moving_Totals.xlsx
- (9.21 KiB) Downloaded 157 times
- gtonkin
- MVP
- Posts: 1192
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: Ending Balance in Period Rollup
You could look at adding an attribute to your period dimension e.g. NonCumulativePeriod and set it to the underlying month that it should read from i.e. Q1 would read from Mar. A rule could then be written to derive from the NonCumulativePeriod when the Period is at a C level.