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?....
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.
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.
Retrieving data ...