Answer the question
In order to leave comments, you need to log in
What formula to do for calculated field in Google Sheets?
Good afternoon! There is a pivot table, column F must be presented as a percentage, I did the calculations manually using this formula
. I need to do a similar calculation, only using the calculated field in the pivot table. It seems to me that the formula is the simplest, I'm just new to Google Sheets. I hope I can find help on this forum. After my calculations using this formula, I get the following error
Answer the question
In order to leave comments, you need to log in
Good afternoon,
Your task is not entirely clear and there is no source file. Tried to play your file.
According to the task, since it is not clear what you want, I will state my solutions to the questions, and you will already decide what suits you best:
=C4/ СУММ(FILTER($C$2:$C$18;$A$2:$A$18=A4))
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question