I have a cross able report which has 10 dimensions, 2 out of 10 are key columns like Program and Project.
I have defined URL action for both the fields which If i click on Program it should open the program details in clarity application, If project is selected, it should open that particular project detail in clarity application.
Everything is working fine, But i can see 2 URL links for Project instead of 1.
i.e. Clarity Program & Clarity Project, I want to show only 'Clarity Project' for Projects and 'Clarity Program' for programs, if i click on the respective fields.
You'll need to give more info.
When you say "open the program details in clarity application" and "open that particular project detail in clarity application", are these two separate sheets in the clarity application?
And on the initial dashboard, how is the user choosing between Program and Project?
A sample workbook would really be helpful here.