-
1. Re: How to identify worksheet action came from
patrick.byrne.0Jun 11, 2018 4:03 PM (in response to Rene Raillon)
Hello Rene,
Unless I am misunderstanding the desired result the action could be performed by setting both worksheet actions for worksheet A and B to navigate to worksheet C and perform said action.
Is that what is trying to be accomplished?
Cheers,
Byrne, Patrick
-
2. Re: How to identify worksheet action came from
Rene Raillon Jun 13, 2018 10:01 AM (in response to patrick.byrne.0)Hi Patrick,
Sorry for the late reply. I had thought I had set up notifications but didn't get an email.
Yes, what you are describing is the desired behavior. I will try and see if that works. I was under the impression that you have one field (or "all fields" depending on how you set it up) that contains the filter selection from the worksheet. I didn't know that two worksheets can essentially "share" that output field or maybe I am misinterpreting what you are saying. In essence, the first chart should alter that shared field to say e.g. "= Net Sales" whereas the second chart should influence the field by saying "= Gross Profit".
I have come up with two different solutions for now. One that worked with the data model as I had it before changes and now one where I effectively have two worksheets C and D that are set up the same way just with different measures. In the first instance, I noticed that "Net Sales" (as an entry of the "KPI" field) only really impacted figures of the first chart whereas "Gross Profit", "Sales Quantity" and "Costs" had an impact on on the second chart. I grouped accordingly and added that group in worksheet C as a detail to the marks card. That would allow me to read the group titles I had given and proceed from there.
The cleaner setup as of now is to simply generate two target worksheets. At the same time, I would be happier to only have one to deal with.
Best,
Rene