topic Re: CAMPO CALCULADO EN PIVOT TABLE in App Development

CAMPO CALCULADO EN PIVOT TABLE

coricosav — Sat, 16 Nov 2024 05:49:41 GMT

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 — Thu, 16 May 2019 04:22:10 GMT

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 — Thu, 16 May 2019 15:06:16 GMT

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: