1> "Time"." Year"
2>"Base Facts"."Actual"
3>"Base Facts"."Actual"
I would rename the columns ( no. 2 & 3 ) as shown in the snapshot below.
Column formula of column no 2
Column formula of column no 3 , You can have complex calculation - In the given example I have used a very simple one )
Save the report. Actuals
Go back to home page and once again navigate to GL Financials Take 2 to 3 measures for example in the analysis and capture their names from the respective column formulae.We would need this while creating a dashboard prompt. Look at the below snapshot.
"Base Facts"."Actual"
"Base Facts"."Balance"
"Base Facts"."Veriation"
Now go to dashboard prompt editor.Select the option Variable Prompt.Add the details as shown in the below snapshot.
Save the prompt and pull it on the dashboard with the report Actuals.
Select the first measure ( Actual ) and hit apply.You will see the Revenue measure values getting populated in the second column while values of 3rd column would base upon the 2nd column that we select from the prompt.
You may find blogs on changing the column name dynamically.
