Issue with Hideprefix and Current selections box

[#1]

Hi All,

       I have a requirement where I need to show the [As of Date ] of the data source file.. Here is some sample data ..

Title        As of date

Vendor    31/12/2011

Location   10/01/2012

Project     31/01/2012

I need to show the As of date of the Project in one of the sheet..

In order to do that I have written a simple if condition (if(Title='Project',[As of Date]). This works fine but the problem is all the time a selection is need to be made in the Title field so that the same will reflect in the Current selections box.I thought of hiding the field using the Hideprefix but I dnt know it is not working..

Any solution other than this are appreciated..

Attaching the sample document for your reference..

Thanks in advance..

[kaushiknsolanki · Accepted solution]

HI,

     Try this expression

     =only({<Title= {"Project"}>}[As of date])

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

            Thank you for Quick reply.. I forgot of doing the same in Set analysis..

Regards,

Lavanya