List Object Data hiding

[#1]

Hi All,

I have two filters 1)Month----All Month names.

2)Yeartodate---Having YTD, MTD as Values

My requirement is i have to show both YTD& MTD only when any month selected in Month filter. other wise i have to display only YTD in Yeartodate filter.

Please help me in this regard.

Thanks,

Nani

[buzzy996]

u can try,

on ur seconde filtr Yeartodate--list box field expression---something like tis,

if(getfieldselections(month)={list ur month names} ,'Yeartodate','only ytd(do sometyhing for this to get only ytd values)')

[#3]

Hi Shiva,

With this expression can we get MTD ?

[buzzy996]

i think u need ytd,this case right?

sample,but expression will vary accordingly ur needs,

YTD Sales:

SUM({<DateDimensionName = {'>=$(=YearStart(Today())) <= $(=Today())'}>} MeasureName)

MTD Sales:

SUM({$<DateDimensionName = {'>=$(=MonthStart(Today())) <= $(=Today())}>}MeasureName)

[#5]

shiva,

let me clarify you that i just need to show /hide the values of a list object based on the selection from the other list object.

Thanks,

Nani

[#6]

Try this one

[settu_periasamy]

Hi,

try to use the condition layout.

like YTD List Box -> Layout -> Conditonal

put  =GetSelectedCount(Month)

[buzzy996]

yes,ur right..for that purpose only i given expression on my first comment..if u select some values on ur month field "getfieldselections(month)={list ur month names}" then it'll show automatically corresponding values on ur second filter.