8 Replies Latest reply on Nov 30, 2018 12:04 PM by Joe Oppelt

# How to do this kind of legend?

I need to extend this a bit, but I'm struck to show First Class Same Day legend separately with this logic. Please see below:

1) ship mode = First Class and  Region = Central then First Class

2) ship mode = Same Day and  Region  in Central, East then Same Day

3) ship mode = First Class and  Region  in  South West  then  First Class Same Day

and for Total

4) ship mode in  Same Day , First Class and  Region  in Central, East, South West then  Total

For  point 3 above, I'm trying to show legend separately but I'm struck being Region having only value which is  South West ? Not able to break this down to show two legends with single value .

when i select First Class Same Day in parameter, it should show graph with two legends and their respective colors seperately.

• ###### 1. Re: How to do this kind of legend?

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.

• ###### 2. Re: How to do this kind of legend?

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.

See attached.

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.

See attached.

• ###### 3. Re: How to do this kind of legend?

Hi Joe,

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.

Bar Chart:

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)

Thx

• ###### 4. Re: How to do this kind of legend?

In the attached I made a new calc for colors on the second sheet.

• ###### 5. Re: How to do this kind of legend?

Hi Joe,

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.

Thx

• ###### 6. Re: How to do this kind of legend?

I'm not sure I understand.

Right now we see this:

What do you want to see?  What should be colored differently?  (And is that only to occur when [Show] is set to this setting?  Are the other colorings OK for the other selections of [Show]?)

• ###### 7. Re: How to do this kind of legend?

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)

Thx

• ###### 8. Re: How to do this kind of legend?

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?