Help on conditional show of a pivot table column

[#1]

Hi,

I have a pivot table with an ID and a date field (YYYYMM) as dimensions.

One of the expressions is a delta calculation between revenue and revenue one month before. How can I hide that delta column for the latest month?

So I would have

201408 (latest month) with revenue column

201407 with revenue and delta column

201406 with revenue and delta column

etc.

Thanks.

[sundarakumar]

In the expression where u r calculating the Delta add a condition like

if(monthfield<>month(today()),  ...expression...  , null())

-Sundar

[#3]

Unfortunately, this has no effect in my application.

By the way, my assumption was that I have to work with a Conditional expression and not with the Expression itself to suppress the whole column. Am I wrong?

[sundarakumar]

u want to supress the entire row or only the column which says delta for the latest month alone?

[PrashantSangle]

Hi,

Try like this in delta expression,

If(num(month(datefield(YYYYMM)))<>num(month(today())),delta Expression)

Regards,

[sundarakumar]

pls share the expression that u have used and sa sample data of how it is in the back end?

[sundarakumar]

I guess this expresison would suppress all '"September" data all together.