Thank you for your reply Vivien, but;
I am using 10 different tables in my dashboard. Sometimes, i need to calculate dimesions, because some dimensions of my objects are not selectable by user. I need to show a dimension from a table based on a conditions of a dimension from another table and this dimension is not selectable by user it is defined by me.
I do not know any options to select my desired results without user's direct interaction.
TaxChoice is a "choice" but does not equal to my TaxType column by means of merging two tables.
LOAD * INLINE [
Dimension, Selection_total, Selection_surcharge_only
Surcharge Only, Total, Surcharge Only
What about this ? With this 'inline', you create 2 lists of selection : Selection_total, Selection_surcharge_only ; each list only contains one value. It is like a button for users.