Actions are working fine. But, selecting 2 or more avg's on the left worksheet and expecting to See a Sum() is where I was confused.
Thanks a lot Shinichiro. You are certainly doing your magic.
But, when I used plain excel to calculate for how long it takes for first 3 queues in total. I do this. First sum the queues within each case (including if a queue has multiple recurrences, and then Avg, of those 3 is 22.66 days. Which seems to be logical.
If I pull up all records, I see 76.6 days instead of 100+ days that your solution shows. Could you please check?
Also, this should reflect for other charts too. When we slice and dice, it does not seem to give right answer.
Could you please check?
I'm sorry I'm not following your logic,
The calculation simply add this value.
What is in the excel column A~D?
I'm sure I don't yet understand your expected logic.
Or attaching Excel file is the fastest way.
And this uses table calc, and table calc should be set on each individual Worksheet.
It's very fragile based on the which dimension / detail is included in each worksheet..