Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi -
I am working with a single data source but two worksheets.
How can I dipslay the opposite entries on the two separate worksheets (Tab 1 - Closed tickets and Tab 2 - Open tickets). It seems that the filter (status=closed) aplies to both worksheets, how can i separate the two? Is that possible?
Thank you for your help!
hiii zvirina123
this can be done but its tricky.
you need to create two data islands ( dataisland for tab 1 and dataisland for tab 2) which will have the field ticket with values open and closed.
then modify your tab1 charts expression in such a way that the value of open and closed will pass through the selection made in the data islands 1.
and the same way for second.
-Nilesh
Hi Nilesh,
What do you mean when you say data islands?
Thank you
Hi,
It will be best if you share the data with us. That will give us more clarification about what you have and what you want.
Regards,
Kaushik Solanki