Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Pramodgc3,
have you tried set the Totals function to None at settings? If not, try it
G.
I need totals but in totals field i need to use expression only for some columns other column should display totals
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.
Look into Dimensionality(), it can offer you the solution to just that:
The second dimension... or how to use secondarydimensionality()
Something like this: