Hi ,
I am trying to use the V#Trailing2-12MonthTotals in my reports. Could any expert users please advise if the TrailingTotal in View Dimension works only for P&L numbers or they work for Balance Sheet and Retained Earnings totals also.
Any reponse will be much appreciated.
Thanks
Sam
The V#Trailing[n]MonthTotal members are typically used for P&L type accounts or BS activity. I'm not sure how many people would find it useful to know what the sum of a number of months of a BS ending balance is.
Just did a test and it looks like it's only working for P&L for me but that makes sense since BS accounts are typically loaded YTD each month and so you wouldn't typically need to see if periodically.
