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]

Hi revathi, can you post your expression? most probably you are using a field without aggregation and it has a different value per Department.

Also, if this is a straight table check, in the expressions tab, if that particular expression has cheched the 'Without Totals' option in the 'Total Mode' options group

[#3]

Hi,

Go to Chart Poperties-> Prsentaion and select the first dimention and click the check box "Show Partial Sums".

Hope this will help ...

[#4]

Hi Ruben,

Let me take a simple example  Sales1 i have used in calculated dimension   aggr(sum(sales),Region)

Sales2 i have used in the expression SUM(Sales).  i am using pivot table and have checked show partial sum option , it will give partial sum for all the expression values but not for the Calculated expression.

Region     Sales1      Sales2

North        100           100

South        200           200

West         300          300

Total          -              600         

[#5]

Hey Subaraja,

That would not help because it will only give partial sum for expression values not for the Calculated Dimension values.

[jonathandienst]

A dimension is not summable. If you want a sum you will need to show Sales1 as an expression, not a dimension.

The Aggr() expression you have for Sales1 is identical to Sales2 {Sum(sales)}, so perhaps you should explain what you are trying to achieve.

HTH

Jonathan

[rubenmarin]

Hi revathi, aggr() returns multiple values, you need to enclose that function in an aggregation function like Sum() to tell QV what to do with all those values, so your expression can be:

Sum(aggr(sum(sales),Region))

And as Jonathan said this should be an expression, not a dimension.

[#8]

go to presentation in your pivot and use total on last row  but you can use straight table i think it will work with you

or normal table and use the sum inside the dimension page and type it inside the comment =sum(FTE)

or you can use a variable and store the summation value and use it in your table .

[#9]

Hey Jonathan it was just an example

i have requirement in a way where we should be able to see total of a Calculated dimension. i just wanted to make sure that whether it can be summable or not

[#10]

yeah Ruben as per requirement i had to use the value in calculated dimension not in expression so i was not able to get total at the bottom