so value passed now? Now make the prompt apply button as autoapply and check. It will pass to the report. Can you please mark the helpful answers

what is the target page prompt displayed?

create a sample single column report with navigation to target page with the source agreement column. Column name should be exactly same as what inside the prompt(no upper ,lower nothing extra). Then try navigation. I strongly believe that your existing source report is incorrect. So create a single column report and try.

what is happening if you choose a value from prompt in first page, then just go to the second page(target page) from the menu on top?

please Keep the same prompt in first page in second page also and show me the output

Show me 1)first reports column formula for Source agreement 2)prompt column formula for source agreement 3)Upper only in one column? or you have added it in upper(source agreement) in prompt also? 4)what is the prompt shows in the second dashboard page. (Please add a prompt in the section itself for testing. Later on you…

Dear Chandra, When you click on it , It will not change. That is how it works. But once you navigate it will capture the value in presentation variable in the second page(not in first page). in the second page keep the prompt(or make a new one to avoid confusion and remove the apply button. ie , it is auto apply). in the…

It will not , But make the the prompt as dashboard level and come back to the page. You will find the value will be reflected there.

We will get it done step by step. 1)keep the first report in a dashboard page. 2)Keep the prompt also in the page(for now to test) a)Column formula of source agreement column should be exact match with the source agreement column formula. b)keep a presentation variable Can you paste some screenshots.

Dear Chandra, 1)did you kept the prompt in source report dashboard page and target report dashboard page? 2)Both the column formula should be same(1 in prompt and 1 in report) 3)Did you use the navigate to BI content feature

Dear Chandra, Create a prompt and presentation variable for the column source agreement and use it as default prompt in a dashboard page and keep the report in the same page . Also keep it in the page where your first report resides. Check the screenshots above and let me know which part is not clear for you.

It will not pass. Only the one you clicked will be captured and can be used in another subject area.

Clicking on one value and passing another, also navigating to another subject area ... Why not navigate from source agreement column, so that you can pass the value. Check the below blog. May be helpful though i am not sure.

Dear Christian Berg, You have been one of the most helpful person in this forum(You are Gandalf the grey ).. I have got help from you several times in past few years. But many people here will not understand sarcasm or wit as english is not our mother toungue(but somehow we managed to learn a bit). So people who see your…

Can you try the below formula, timestampadd(SQL_TSI_DAY,3*7,TIMESTAMPADD(SQL_TSI_DAY,-DAYOFWEEK(timestampadd(SQL_TSI_DAY,-DAYOFYEAR(CURRENT_DATE)+1,CURRENT_DATE))+1 ,timestampadd(SQL_TSI_DAY,-DAYOFYEAR(CURRENT_DATE)+1,CURRENT_DATE))) Pass the week number to the formula and check.

Did you try the second approach? Keep the report in a dashboard page and use a presentation variable and a prompt. Let me try in my environment and will update you. Below two reports are from two different subject areas. Prompt Settings You can choose the default prompt for dashboard page from dashboard page properties (or…

can you keep the below code in advanced tab (Prefix) of your analysis and check export SET VARIABLE DISABLE_CACHE_HIT=1;

Create and keep the second report in a dashboard page and keep the reports with hidden prompt in second dashboard for the column u need to filter and use presentation variable

what is the column formula for %spend?

What exactly you are trying to report? Could you provide some samples?