1 Reply Latest reply on May 22, 2013 10:59 PM by Jim Wahl

    Problem with Returning Most Recent Period using Table Calculation as a Filter

    Cody Bakken

      I'm trying to create a view that defaults to the current period (we have custom fiscal periods) by using LAST() = 0 as a filter.  I use this because I need to be able to do table calculations such as difference between current period and the previous period in my report.  The problem is, if I have a dimension that does not have data in the current period, the table will return the last period where there is data (see Tables in the attached file). 

       

      What I'm looking for is a way to return the results for the current period only and not just the last period in which there is data while still being able to use period over period calculations.  I've attached an example of what I am seeing.