I have a question regarding calculated fields in a pivot table.
I have a 8 column table in a sheet that I used to make a pivot table in another sheet. I want to add a field that is the conditional sum obtained from two of the columns from the table in the first sheet.
I tried using this formula:
When I click "Add" nothing happens and "TabellaInterventi[Confermato?];" becomes gray. I still don't know what that means as it doesn't provide any sort of indication.
I tried another formula, that not only references the table, but also the sheet:
To no avail, but now I get a syntax error. I also tried surrounding the column names with "", but it doesn't work.
As far as I know (and I know very little) the syntax is correct, but the formula just doesn't work.
I'd be glad to receive any kind of help, thank you.
Also let me know if you need more details to help me