Expression in Total field of table

[#1]

Hi all,

Is it possible to write an expression in Total field of table object.

I have an table with 10 columns, i am displaying some values in columns also total at the bottom.

In one of the column i have values with % i need to show % in total by calculating it from the total of other columns.

Example:

A     B     C

2     2      1%

3     4       1%

--------------------------

5      6      6/5          

Is it possible to get the total of Column "C" from the expression?

Regards,

Pramod

[undergrinder]

Hi Pramodgc3,

have you tried set the Totals function to None at settings? If not, try it

G.

[#3]

I need totals but in totals field i need to use expression only for some columns other column should display totals

[undergrinder]

Yes, you need it, I didn't say to turn it off.

You can set the Totals functions (or expression) by measures (sum, count, min, max, avg, none).

At the % maesure set this function to None.

G.

[sunny_talwar]

Look into Dimensionality(), it can offer you the solution to just that:

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

Something like this: