Previous year's measure cannot be displayed in table with account dimensions

[TF2]

Hi Team，

Define table including account dimension.

When attempting to create a limit measure for the previous year's results, the account dimension's calculated measure only allows the selection of “Shift Previous Value” and fails to display the previous year's results on the column axis.
How can we display the prior year actuals in the columns?

※Please find the layout attached for your review.

・I want to display the previous year's results as columns as shown on the left.

・The image on the right was tried with a restricted measure, Can't do it because “Shift previous value” is not shown.

Thanks,

Taniguchi

[Yogeshwar_M · Accepted solution]

Hi @TF2 ,

Create calculation measure in model like this, use previous calculated measure in this 

 

Thanks 

[TF2 · Accepted solution]

Thank you. I was able to get the previous year's actual values from using the method you provided.

[Yogeshwar_M]

Hi @TF2,

In two way you can achieve this

1. In story create restrict calculation 

Select date as previous interval 

2. Create model level calculation 

Lookup(Measure,Date=previous(month,12)

2. In story restrict on above measure

You will get the last year actuals..

Kindly accept the solution it you find it useful. 

Thanks.

[TF2]

Thank you for your response. The first method is not possible because it is not displayed as others have suggested. I have tried the other method and it does not seem to calculate. Is there some formula that is incorrect?

[Yogeshwar_M]

Hi

1. Create one more measure in model and just use sum aggregate on this calculated lookup measure add date dimension in measure.

Or you can

2. Create restrict measure in model 

also create accountlookup on restrict measure.

This will Fix your issue. 

Thanks 

[TF2]

Thank you very much.

I have set up the model according to the information you provided, However, it seems that the diagonal line is drawn and the calculation is not done.

We are assuming that the 2024 actual data will be entered into the 2025 previous year's actual data column in the image.

Is it correct to say that the calculated measure is set for the image?

We apologize for the inconvenience, but could you please confirm this? 

[William_Yu]

In the section screenshot, you should choose option  Navigation -> To Date -> Year,  can't judge what you selected on your side. 

[TF2]

Thank you for your response. I selected it as advised but it does not show up.

Navigation -> Full Time Interval -> Year ,The overall amount for the previous year is displayed for each month.
What I would like to achieve is to show the previous year's actual amount for each DATE. If it is a year, I would like to display only the previous year's total amount. If it is April, I would like to display only the previous year's April results.

[William_Yu]

Sorry, I mis-typed in last reply, it should be Navigation -> previous -> Year

[TF2]

Thank you very much. The navigation you provided is not displayed. This is a report for a model with an account dimension, so this navigation is on the account side (rows) of the account dimension, but not on the column side. Is there any alternative? Please let us know.

[William_Yu]

I'm also having a model with account dimension, I don't think it's a problem... Not sure why the navigation option is displayed.