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

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


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?



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