Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I have a requirement. I have a couple of list boxes (List boxes A, B , C, D say) in a sheet. and then there are few charts (say X, Y, Z).
The problem statements is when any value is selected from List box A, Chart X shouldn't show any data even though it has relevant data to be shown. And again when any value from List Box B is selected, then Chart Y shouldn't show any data even though it has relevant data to be shown. And in any other time if none of the value is selected from either A or B, both the graph should act as usual. And if list boxes C or D is selected, the graphs should still show data.
Please help.
Bikash,
You can use Calculated Condition (or Show Condition to hide the charts completely), and use GetSelectedCount() as condition. For example, calculated condition for chart X would be
GetSelectedCount(A)>0
or even simply GetSelectedCount(A) - it implies ">0"
I hope you'll figure out the rest.
Regards,
Michael
Edit: I got it just the opposit way, the condition for X is GetSelectedCount(A)=0 (that is, no selections)
Edit 2: See attached, I added calclution conditions to charts X and Y
Hi
Without view the data model and sample file, its difficult to give solutions. Can you please provide a sample file?
Thanks for the response.
Please find attached a sample file.
Thanks
Bikash,
You can use Calculated Condition (or Show Condition to hide the charts completely), and use GetSelectedCount() as condition. For example, calculated condition for chart X would be
GetSelectedCount(A)>0
or even simply GetSelectedCount(A) - it implies ">0"
I hope you'll figure out the rest.
Regards,
Michael
Edit: I got it just the opposit way, the condition for X is GetSelectedCount(A)=0 (that is, no selections)
Edit 2: See attached, I added calclution conditions to charts X and Y
Hi Bikash,
on chart properties>> general tab>> calculation condition, use expression, for example :
let say for Chart X, you can write like, =count(distinct A)>=1,
mean when 1 or more values will be selected in list A then it will be calculated. and you can show a message to user to select 1 or more values from list A to see the data.
you can manage the others in same way...
Hi
Try like this
GetSelectedCount(Revenuefacttable.BillToName) = 0 In calculation condition.
Its helps.
Thanks for the response.
Really appreciate it.
Great! It worked. Thanks and appreciate it.