Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If Day is a dimension then write:
if(Day=1,Day, Null()) and check the box "suppress null values"
Thank you for the response but there is no dimension in table object?
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
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
please check this example
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
Sorry,
I don't understand the issue... can you attach an example?
Hi Omar
Thanks for the reply but what if I didn't want min and wanted to say fix to 3rd ?
Hi Emma,
Then you can use Min({1} Date,3)