Custom Total(Decision) in Pivot table based on the Cell value

[#1]

Hello i have a pivot table like this,

Dim1	Dim2	M	T	W
ASIA	source1	4	5	2
	source2	2	6	0
	source3	0	7	5
	Total(Decision)

So, Instead of taking total at the end i want to take some decion based on the values of souce1 source2 and source3 for every column.

for example, if in first row it should display Decision as EXE.

thanks

Lavi

[#2]

Any response for this question?

[neha_shirsath]

Hello Harleen,

Can u pls tell me what exactly total u want to display.

Coz in chart property> In Presentation tab u can select Dimension & Expresion and check on Show partial sums.

[#4]

hi

what you want exactly?

[#5]

@neha,

                 i don't want partial sums. if you look at above table,

for example for particular day  values are

source 1  4

source 2  2

Source 3 0

Result   EXE

So because Source3 has value Zero so i want to show Result is EXE. So, instead of showing sum at the End i want to show some Characters based on the above 3 values.

In the same way for second column values 5 ,6 7. I will say Result is OK.

So , some kind of Custom Total.

thanks

Harleen

[#6]

hi

    right clik on pivote-- > presentation---> select dimension ---> check on show partial sum

or

    add expression and write  ( Column(1) + Column(2) + Column(3) )

hope it helps you

[#7]

Vishwaranjan,

                     There is only one expression in the above pivot table.

so Column1 + Column2 + Column3 doesn't exisit.

Dim1 and Dim2 are Dimensions

and Monday(M), (Tuesday)(T) is also a dimension.

thanks

Harleen

[#8]

hi

what  you exactly want the total?

i think if you take all field as dimension then write sum(M+T+W).

[er_mohit]

hiii

use name and id in dimension and through inline function in script add total field value in same field of source

then use expression for M,T and W

alt(if(name='total' and tue=0,'ok',

if(name='total' and tue<>0,'exe',tue)))

hope it helps you