Dimension value + 1

[#1]

Hello all,

I have a small problem with value presentation in table.

As you can see on screenshot, when I just add 1 to the week dimension, it just shows data shown in the blue square.

Do you have an idea how to get the values in green one?

Best regards

[PrashantSangle]

Hi,

Better if you create Week +1 dimension in script

or in your expression

modify it like sum({week={"=$(week+1)"}}sales)

Regards

[#3]

Hello.

would you be so kind to show me how to do this?

I will send you excel file.

[PrashantSangle · Accepted solution]

Hi,

Create straight table

take Week as dimension and

Sum({<Week={"$(=Week+1)"}>}[hours]) as Expression

PFA

Regards