3 Replies Latest reply on Feb 3, 2016 4:43 AM by Patrick Prasquier

    Lookup on values that can't be displayed?

    Patrick Prasquier

      Maybe you can help me on this issue... I need to display last year's sales value for today's month. By creating a lookup calculated field, I get the figure I need for all months. But I only want to display (and calculate comparison values) for today's month. And, of course, using a date filter breaks my lookup (if I display only current month, then 12-month-ago data are not available to be looked up)...

       

      I've thought about using "Fixed" level-of-details, but then, I couldn't find any compatible "lookup" function and I couldn't think of any calculated field on which I could fix dimension so that year-2 = year-1, year-1=year0 but year-2!=year0.

       

      Any idea?