W
W
warussia2022-01-28 20:52:31
Google Sheets
warussia, 2022-01-28 20:52:31

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
61f42e479f471806285257.png
. 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
61f42e549b57a874105655.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
T
Timur Takabaev, 2022-01-28
@tim8ska

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:

  1. The formula can be written outside the pivot table, as you gave an example on the first screen, then there will be no error in it. This data can then be displayed on the next tab as you need it.
  2. You can write a formula in your original spreadsheet that will calculate the percentage of the current category, then simply output that value to a Column. My Formula =C4/ СУММ(FILTER($C$2:$C$18;$A$2:$A$18=A4))
    61f43425b92b9832830934.jpeg
    Result:
    61f434dff1be4753912391.jpeg
  3. The third and easiest option: in the pivot table, you can add another, the same duplicate column (I have the main column "Value", so I add "Value" a second time), but "Show as" is already in% of the parameter you need column or row. Here is an example of what I got:
    61f4355f5ca9b389129719.jpeg

W
warussia, 2022-01-29
@warussia

Thank you, I did the calculation according to the third option, I got such a table
61f4f4dfd9813110226647.png
. Now there is one more question, is it possible to make these calculations only for column J "Total", as in my very first screen?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question