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?