how to add an error message?

[jim_chan]

Hi guys,

i wanted to add in a error msg on my pivot table.

At the " condition unfulltiled" i edit the message to " please select a dimension". then i click ok.

but nothing happen...

i think i have missed out some stepss....

Anyone here can guide me through?

RGds,

Jim

[avinashelite]

Could you please share the condition ? what you have written

[jim_chan]

That's all i have done. so what's next? click ok? i did, but the error msg didn show up.

[Anil_Babu_Samineni]

Might be your expression is wrong, That's why it showing Un filled. You need to add Condition Expressino from general tab, That's called

=GetFieldSelect(Dim={})

[raghvendrasingh · Accepted solution]

Hi,

First Give Any Calculation Condition in General Tab, like as

=GetSelectedCount(Dimension) > 0

Then give the message, now it will work.

Thanks

Raghvendra

[beck_bakytbek]

Hi Jim,

try the following steps: copy your Expression and add into calculated condition, activate then the error message, check the text: Calculation Condition Unfilfiled and add your text.

i hope that helps

beck

[jonathandienst]

You have not set a calculation condition, so the error message will never be shown.

[avinashelite]

In the General tab>Calculated condition

=GetSelectedCount(field_name) > 0

[jim_chan]

ok.. thanks!

[Chanty4u]

first give the caluclated condition and den add ur eeror msg in genral tab