I have a text box which displayes the following data: Oracle, Password Reset, Cyborg and STW. The information comes from and excel file called software in which there is a tab called Summary. I want to remove Password Reset from the text box and keep Oracle, Cyborg and STW.
I have tried entering the following statement in the Calculation Condition section in the General Tab, but I get a message saying: Calculation Condition Unfulfilled.
Then click the suppress null values check box. If you are talking about a dimension in a pivot table then do the same.
If you are trying to calulate some value in a pivot table with Software as the dimension you can do the above or you can set the dimension as Software and then do:
The answer is probably easy, but I seriously don't understand the question. A calculation condition is almost certainly not what you want, though. What are you actually displaying in the text box? What's the expression for the text itself? What do you see? What do you want to see instead?
Then click the suppress null values check box. If you are talking about a dimension in a pivot table then do the same.
If you are trying to calulate some value in a pivot table with Software as the dimension you can do the above or you can set the dimension as Software and then do:
