Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Create straight table
take Week as dimension and
Sum({<Week={"$(=Week+1)"}>}[hours]) as Expression
PFA
Regards
Hi,
Better if you create Week +1 dimension in script
or in your expression
modify it like sum({week={"=$(week+1)"}}sales)
Regards
Hello.
would you be so kind to show me how to do this?
I will send you excel file.
Hi,
Create straight table
take Week as dimension and
Sum({<Week={"$(=Week+1)"}>}[hours]) as Expression
PFA
Regards