pivot table is not showing some values on click event..

[#1]

i made a pivot table  which has come conditional expressions which should show some values on clicking one of the year which is kept in a list box

i used that expression in text box it is showing values but not in the pivot table.

Please Tell me what can be the reason?....

[jonathandienst]

Hi

Please provide more information - your data structure, the pivot table dimensions and expressions, text box expression; or better yet, upload a sample of your model.

Regards

Jonathan

[tresesco]

If it working in the text object and not in pivot, possibly there is an aggregation issue behind this. Could be looked if you can share sample.