I don't understand what you are trying to do.
What do you mean by "legend"?
I have your workbook open, but I don't know what to aim for here.
OK, I think I understand.
You want the same colors and ship modes to be on the second sheet as they are on the first, controlled by the [Show] parameter.
I took Ship Mode filter off the second sheet and replaced it with the [Show Filter] calc that is being used on the first sheet. (I also made the filter "apply to" both sheets together so that they work identically, though it really doesn't matter in this case since the calc is built using the param, and the only logical thing to do with that calc is filter for "True".)
And then I put the [Show Colors] calc on the color shelf. That's the calc being used on the first sheet.
Appreciate in getting back to me.
Earlier we did this just with ship mode correct. Now similar to tab F, I need to do this Legends with the stated criteria with Ship Mode and Region combination.
First Day ( Blue Legend)
Same Day (Orange)
FIrst Day Same Day ( Blue and Orange seperately)..but here I'm struck given that Region has only value , I'm not able to write the calculation and
Total (some color legend)
This looks good...can we make one change on this. Like when we select First Class Same Day , I need to show break down by different colors , having one List of value for Region which is south west , I'm not able to break it down to two colors.
Please advice if this is possible at all.
Yes Joe. The other coloring are totally ok.
Only with First Class Same Day , we were showing one color correct which is purple... ( i need this split down to two colors). I think this is not a possible case since we need to identify First Class Same Day like below:
ship mode = First Class and Region in South West ( we can't really say show two colors being South west is only one value)
I still don't get it.
What would you want the second color to go on?
Are you saying South and West would each have a separate color?