Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
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.
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: