Skip to Content
0
Former Member
May 11, 2018 at 01:38 PM

WEB Intelligence - cross table - Previous()

193 Views Last edit May 10, 2018 at 01:54 PM 2 rev

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?

Attachments

capture2.jpg (27.0 kB)
capture.jpg (28.1 kB)