CAMPO CALCULADO EN PIVOT TABLE

[coricosav]

Hi,

I have a pivot table and I need to include one calculated field with the next fx

%TTR= ('SAME DAY'+'D+1')/('SAME DAY'+'D+1'+'D+N')

[Anil_Babu_Samineni]

Question not clear, Perhaps you want to aggregate with One field

Sum(Aggr(('SAME DAY'+'D+1')/('SAME DAY'+'D+1'+'D+N'), Field))

I feel, Above mentioned are dimension else please explain.

[coricosav]

Hi,

The dimension is TTR, this column has 3 options type text: 'Same Day', 'D+1' and 'D+N'.

For the calculation field  my master table has 1 column with the number 1 and I apply the fx sum( field) with  others dimensions for example v_rep

I need a new column TTR%:

Example: