Ending Balance in Period Rollup

Post Reply
ashokjb
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

Post by ashokjb »

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
Attachments
Moving_Totals.xlsx
(9.21 KiB) Downloaded 157 times
User avatar
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

Post by gtonkin »

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.
Post Reply