How to display "All" rows in the list using Excel as datasource
I am new to this issue, Using Excel datasource, i have created a Dashboard(which contains 2 Pie charts) and a Detail report. Where these 2 pie charts are not related to each other but links to the same Detail report. To filter the Detail report i have created two prompts where we get the values from these two different pie charts. When i am using the Chart interactivity i have given value to the 1st prompt but i am facing issue to pass the default value for the 2nd prompt of Detail report which belongs to 2nd Pie chart. Can anyone please help me how to pass the default ALL value to the 2nd prompt in chart interactivity.
Thanks in Advance,