Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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.