Skip to Content
0
Jun 17, 2021 at 03:40 PM

Cross Calulation - How to make comparison with value 12 month earlier.

143 Views

Hello together,

I have a very specific question. We are using an account dimension and want to show the value for the current date and the date 12 month ago.

It is used here also a date dimension besides the account dimension which has the values. I was creating a cross calculation assigned to the date dimension in the following way:

Now when setting up the Values or Input Control I am struggling.

How to set up the last step for the cross calculation so the value 12 month ago is shown?

BR/

Attachments

1.png (374.9 kB)
2.png (12.2 kB)
3.png (39.0 kB)
4.png (155.1 kB)