I created a pivot chart and given conditional selections using
=SubStringCount('|' & Concat(distinct Dimensions, '|') & '|', '|Currency|')
In Dimensions List Box I have some other variables like Reporting, Office Etc,
It is working fine on my local machine.
But when I place in browser sometimes its working and some times its not working automatically.
Is there any reason for this?? As it is happening automatically.