Table Variance does not appear when using dynamic system date as reference

[DebjitSingha]

Hi community,

I have a problem showing variance between two dates in which both are dynamic with the system date.

Imagine we are on February 2021, so we will create a table that shows the month before for the actual year and the month before for the previous year ( image-1.png). We will compare both dates with variance.

If now we are in March 2021, the variances disappear when the columns become February 2020 and February 2021. (image-2.png)

Is there any way we can see variances without having to create them every time the date for the columns changes?

Thank you so much in advance.

Leticia Garcia

[DebjitSingha]

If you are looking for similar setup related example here is another with steps (similar requirement). Check my 2nd reply-

https://answers.sap.com/questions/13309345/calculations-in-table-cells-in-sap-anaytics-cloud.html?ch...

Hope this helps. Let us know if you have any query around this topic.

Thanks,
Debjit

[Former Member]

Sure, thanks for you solution Debjit!

[DebjitSingha · Accepted solution]

Hello l140897,

Create one restricted measure on account dimensions for previous year column (show below).

Then add calculated measures between column1 and restricted measure (created above). This should work.

Hope this helps. Let us know if you have any query around this topic.

Viewers/ readers - If you find shared information helpful, feel free to up-vote (arrows on the left hand side)

- Debjit

[Former Member · Accepted solution]

Thanks for your answer Debjit,

The thing is that we cannot use a restricted measure as the measure of the table is established with a measure input control. We cannot do a restricted measure to the measure input control.

Do you know about any other workaround?

Thank you in advance.

Leticia

[DebjitSingha · Accepted solution]

Hello Leticia,

You can use "New calculated input control" (shown above) instead of input control on measures. Setting up such comparision based on user input of date dim is quite common.

Or may be I am not getting your point here. Can you share your existing setup (use insert image instead of insert files).

Thanks,

Debjit

[Former Member · Accepted solution]

Hello Debjit,

The problem with the solution you give is that, if we create a new Calculation input control (red rectangle in the image) there is no possibility of selecting any accounts, it is only possible to select generic dimensions, date and category.

We need to perform a restricted calculation over the measure input control configured in the story to give flexibility to the user when selecting the measure for variance analysis. Then, in the measure of the selection context (green rectangle in the image) there should be an option for this purpose.

Thanks in advance.

Leticia

[DebjitSingha · Accepted solution]

l140897 I think I got you point and issue now. I was answering similar query this morning.

Cross claculations should work in your scenarios. Let me post some example to help you here.

Thanks,

Debjit