Restricted dimension

[prrajendran]

Hi Experts,

i have a straight table which has Reference number as dimension and two expressions.

my first expression brings the occurences of the reference number for the selected month

second expression brings the occurences of the reference number for the selected month and past 2 months from selection.

the expressions working fine.

but i want my dimension to be filtered only for the selected month.

i.e., 'RefA' reference number can be in multiple months

'RefB' in just the selected month.

then i want to display only 'RefB' in my dimension. how can i do this. please help

[Anil_Babu_Samineni]

How is the measure looks like?

[prrajendran]

Expression 1:
count(DISTINCT TOTAL<AcNo>{<full_date={">=$(=min(full_date))<=$(=max(full_date))"}>}ReferenceNo)
Expression 2:
count(DISTINCT TOTAL<AcNo>{<full_date={">=$(=addmonths(max(full_date),-3))<=$(=max(full_date))"},Month=>}ReferenceNo)