conditional expression

[alexpanjhc]

Hi

I have a pivot table that I have dimensions like region,area, stores, sales, appr_book_flags

and then I have expressions like daily amount, daily dollars,MTD amount,MTD dollars,YTD amountand YTD dollars.

I want to show only when book_flags ='Booked' then show the 6 expressions, and then if it is pipeline, i only want to show YTD info and so on.

I think maybe I can try in the expression, conditional I just put my condition, but I do not think that helps.

Anyone knows the trick?

Thanks!

[tyagishaila]

put your expression of condition check in

Chart Properties-->General-->Calculation Condition