Skip to Content
0

WEB Intelligence - cross table - Previous()

May 11 at 01:38 PM

37

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jyothirmayee A May 11 at 04:56 PM
0

Hi,

Try this:

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

Thanks,

Jothi

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
Jyothirmayee A May 14 at 05:18 PM
0

Hi,

Try

Relativevalue() instead.

Thanks,

Jyothi

Share
10 |10000 characters needed characters left characters exceeded