Fixed date in table

[#1]

Could any one help with displaying date in a table for a fixed day.

Scenario, Table column = Day

which is 1st, 2nd 3rd etc.

I want my table to only ever display day 1st REGARDLESS of any other selections.

Is this possible.

Help appreciated.

Emma

[alexandros17]

If Day is a dimension then write:

if(Day=1,Day, Null()) and check the box "suppress null values"

[#3]

Thank you for the response but there is no dimension in table object?

[#4]

When you say 1st day, do you mean the minimum day loaded?

=DATE(min({1}Day)) // with {1} you exclude all the selections

hope that helps,

David

[#5]

try to use a combination of

lets say Date field is A

Min({1}A)

this will bring all data regardless of selection

and use dimension limits

this will help you

i will try to attaché file for this example

[#6]

please check this example

[#7]

Hi  David

Thanks for your reply and this is useful to know, however what if it was not the min I wanted to fix, but say all the 3rds data ?

Thanks again

Emma

[#8]

Sorry,

I don't understand the issue... can you attach an example?

[#9]

Hi Omar

Thanks for the reply but what if I didn't want min and wanted to say fix to 3rd ?

[jvishnuram]

Hi Emma,

Then you can use Min({1} Date,3)