Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to restrict selection made on a particular value in a list box to not affect a chart ?
for example,
I have a list box with MonthNames.
and I have a bar chart which displays Revenue by Months. This chart should omit the Months June and July in the x-axis.
When i select the Months - June or July on the filter, the chart should remain unaffected by the selection, while for any other selection apart from these 2 months, the chart should display the corresponding data.
i wrote an expression like -
sum({<Year={2012,2013,2014},if( Wildmatch(Month,'Ju*'),Month=) >} Sales)
Doesn't seem to be working..it does skip June and July from the chart, but when i select these months in the filter, i get a "no data to display message"
Can someone please help here?
Thanks
Pooja
Hi,
PFA, Tks
sum({$<Year={'2012','2013','2014'},Month={'*'} - {'Jul','Jun'}>} Revenue)
also you use
sum({$<Year={'2012','2013','2014'},Month -={'Jul','Jun'}>} Revenue)
Hi Pooja,
you can try like below,
sum({$<Year={'2012','2013','2014'},Month={'*'} - {'Jul','Jun'}>} Revenue)
Hi,
PFA, Tks
sum({$<Year={'2012','2013','2014'},Month={'*'} - {'Jul','Jun'}>} Revenue)
also you use
sum({$<Year={'2012','2013','2014'},Month -={'Jul','Jun'}>} Revenue)
Hi Devarasu,
Thank you for the answer. It worked
i had to use wildcard so my final expression looks like
sum({$<Year={'2012','2013','2014'},Month={'*'} - {'Ju*'}>} Revenue)