How to get total at the bottom for calculated dimension

[#1]

I have a calculated dimension FTE i need to get Total at the bottom of the pivot chart ? i have used aggregation function could any one of you suggest me how do i get total for calculated dimension?

Department		FTE	Hours	Client
Management		20	10	9
Creative		30	25	50.25
Media		28	30	-
Operations		260.29	22	26
Planning		40.64	12	-
Technology		91.82	13	225.5
Total			112	310.75

[rubenmarin]

Not sure if this will fit your requirements, but in presentation tab you can change the label for 'total', maybe you use someting like:

='Total   ' & Sum(sales)

A little weird workaround but maybe helps you.

[#3]

Nope it does not work

[#4]

use the region as your dimension  and in the expression

just do the sum for FTE and the other it will work i did it .

and don't forget to enable show total in the presentation 

[ziadm]

Hi

Dimension cannot be totaled .. you have to move that dimension to expression

[ziadm]

Hi

Try using Dimesionality function conditions in order to make an aggregation and totaling conditions

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

Regards

Ziad

[Anonymous]

I wish I can see a reason for this sort of requirement...  Just to test your skills???

It should be an expression not a dimension.  If you still want to satisfy this requirement, create it in both calculated dimension and expression (just without aggr), and hide this dimension.