I am Having Problem with Pivot Table

[#1]

Hii All,

        I have a Pivot table containing 3dimensions(Fld.Name,Month And Date) and 6expressions(Latex,MonthToDate(MTD),YTD,Budget,L/Y Actual for month and L/Y Actual for Date).

My Requirement is:-

   1.MTD and YTD shows the value only when Month are expanded,otherwise it will be blank or 0.

And I dont have any idea how to write an expression of LY Actual for Month and LY Actual for Date.

Please guide me.

Thanks & Regards.

Koushik.

[brenner_martina]

Hi Koushik,

you can enter an if-then-else-statement like:

If(GetSelectedCount(Year)=0,

Sum({<Year={$(=Year(Today()))}>} Budget),

Sum({<Year={$(=Only(Year))}>} Budget))

Greetings from Munich