Total qualifier with Only function

[#1]

Hi guys,

Is it possible to use Total qualifier with Only function?

i have a situation where I need to show Dates for my two dimensions.

Something like this...

Table1:

ID  LinkedID

1    5

4    7

Table 2:

ID    Date

1    01/02/2012

4    03/05/2014

5    08/09/2013

7    08/07/2015

Now the chart should be like this:

ID      LinkedID      DateforID      DateForLinkedID

1        5                01/02/2012    08/09/2013

4        7              03/05/2014    08/07/2015

DateforID can be shown by the simple expression 'Table2:Date.

but DateForLinkedID I need to ignore the ID so i am trying to use only(Total<ID>Date) but it gives me dates for ID and not for LinkedID.

So it looks like this which is not what I want:

ID      LinkedID      DateforID      DateForLinkedID

1        5                01/02/2012     01/02/2012

4        7              03/05/2014       03/05/2014

Any suggestions?

Regards,

Saurabh

[#2]

This is exactly I was contemplating too...

Thanks for it..you are wonderful!

Now the only thing that is remaining is to remove hard coded values from the only<Total> expressions and do some concat magic there.