Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Table Box properties

Hi

Want to know the usage of "Calculation Condition" in table box.

Also want to know can we add a calculated field in a table box, if yes then how?

Thanks

2 Replies
Anil_Babu_Samineni

Table box doesn't have calculation dimension feature. So, Instead we can go straight table and the usage is very powerful using calc. dimension because we are restrict the data and it is not good to have until unless we don't have option to use in set analysis (Measure)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
tresesco
MVP
MVP

Q1: Usage of 'Calculation Condition' :

You can put a certain condition possibly based on your data when to display the data in the chart and when not (FALSE). For example, you may wish to display the table box data only when a certain field, say Sales has minimum value 100. Then you can put the condition like: =Min(Sales)>=100. If this condition comes true, the tables shows data, if false, then the chart remains without that data and displays a default message 'Calculation condition unfulfilled' (or the custom error message you set).

Q2: No you can't add a calculated dimension in table box, but in a straight table.