Forum Discussion
Can we use match formula in pivot table's calculated fields?
Hello Community, I'm trying to create a calculated field in a pivot table and there is one formula as below. This formula works fine in my excel sheet, but I can't create one in pivot table as a...
i am assuming you are using data model and power pivot?
- Hi Yea_So - No, I'm actually using the basic pivot table. Any ideas why...?
Hi, Joseph_Hung,
A pivot table is used to organize, summarize and aggregate dataset to answer analysis questions.
so if you have to use a match function, it tells me that either 1. you are using structured tables in a data model to summarize, aggregate your dataset to answer analysis questions. If you are using match function, then you are still in the dataset prepping stage and should not be creating the pivot table until you are done looking up values to match all the information from other structured excel defined tables.
Hi Yea_So
I think the problem might be the Column function here because I put the formula in calculated field and try to click "ADD", but it bounce back to the column function marked as grey below.
