Skip to Content
avatar image
Former Member

WEB Intelligence - cross table - Previous()

I have a cross table with dimensions (date and alphabet) and measure: [random_numbers] in WEBI from Jan-18 to May-18.

I would like to get always the previous values in column Jun-18 and Jul-18 for each A/B/../E (see printscreen).

When I use Previous([random_numbers];1) unfortunately I get only the last values for the last letter: E (always):

Can anobody suggest something how to solve it?

capture2.jpg (27.0 kB)
capture.jpg (28.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 11 at 04:56 PM

    Hi,

    Try this:

    =[RandomNumbers] where (relativedate([date];-1) In ([alphabet])

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Realtivedate returns date, Date for sure is not in the list of [alphabet], so why it should work?

  • May 14 at 05:18 PM

    Hi,

    Try

    Relativevalue() instead.

    Thanks,

    Jyothi

    Add comment
    10|10000 characters needed characters exceeded