Hi Jana,

The reason your parameter is not working is you have "Destination name" as the value.  Change it to "Destination" and the switch will work.  As far as colors go, you will want to place c.Select Dimension on colors, however, you will need to set the colors yourself.

To get your table calcs to work you will need a table calc based filter.  This will allow your table calcs to access the underlying data they need.  The calc for date would look like LOOKUP(ATTR([Date]),0) and you would want to format it to mmmm, yyyy for your view and computing table down.  Let me know if you have any questions.

Regards,

Ivan

The parameter value does not need to match the dimension name.  It needs to match the quoted value in the case statement.

Usually Display as and Value are the same, however you could change Display as to "Destination name" and the param would work fine.

CASE [Dimension Parameter]

WHEN "Airline" THEN [Airline]

WHEN "Destination" THEN [Destination name]

END

I'm not sure what you mean by exclude Year and Month.  You can't remove either from the view as they are needed by the Table calcs, you can hide the headers if you wanted.  Let me know if you have any questions.

Hi Jana,

I get what you are trying to do and understand the problem your facing.  There are a couple ways to go about it.  The easiest is probably to create four sheets then use a parameter to drive the filter.  First you would create a parameter with dates on the 1st of the month, you can do this by clicking on the date field and going to create -> parameter.

Then create a calculated field [Date Table Calc] = [Date Parameter] which you can put on filters and set to True.  You will need to add the calculated field to all 4 worksheets/tiles.

You could get a tile like effect and still keep everything in one sheet.  Let me know if you need more detail.

Below is an example of all measures in a single worksheet.

Hi Jana,

Glad this works for you.  Fortunately the up down arrows are the easy part.  In some cases they can be tricky, however you can use the following custom format for the percentage measures, ▲ 0.00%; ▼ -0.00%;

Let me know if you have any questions.

Awesome!  Glad it worked for you.  When you have a chance could you close this thread?  It will make it easier for future visitors to find solutions.

In fact I just answered a question about the up and down arrows and using table calcs as filters is also a solution I regularly suggest.

Thanks,
Ivan

I think you need to mark an answer as correct to close the thread.

I'm just guessing but it's probably the compute settings on your table calc.