Can we use calculated dimension in table box

[#1]

Can we use a calculated dimension in table box?

[maxgro]

in table box you can only add fields

[sasikanth]

NO you cannot use Calculated dim,

insted calculate that one at script level

like

LOAD

sum(sales) as SALE,,

.

.

.

From.............

......................

and SALE in Table box..

it may help

[Anonymous]

Hello,

You can do that with a straight table (chart) that has dimensions but no expressions. Just make sure that "suppress zero-values" is unchecked in the Presentation tab. This will be like a table box, in that it will show all of the unique combinations of the dimensions you choose as they exist in your data model, but it will give you the functionality of a straight table.