Thanks for yours reply,same what i have done with if condition ,
but for Invoice count parameters selection it used to give me All in title.but i have used formula as
IF [Analysis_Para]='IC' THEN
ELSEIF [Analysis_Para]='IV' THEN
" Total amount Closed"
ELSEIF [Analysis_Para]='L' THEN
"Sum of Lots"
ELSEIF [Analysis_Para]='TC' THEN
"Total Open Count"
For rest if all parameters selection means for Invoice amount,Lots and Trade Count it is working fine.
please let me know how to handle this issue.
Thanks in advanced.
Title_Change.twbx 7.2 MB
I think we have to check field 'Toggle Sheet' where you are using Custom Values.
That might resolve the issue.
Ankit is correct. You need to add `IC` to the Toggle Sheet filter. It is currently missing so even though the Parameter selects IC, it isn't valid per the filter so no data is returned.