How to used FIXED value in formula on Pivot Table?

[llama mama]

Hi,

I'm new to pivot tables. I'm trying to figure out how to add a Formula using Calculated Field with a Fixed value from my data set. The problem is whenever I add a value it automatically sums or counts. I've tried changing the MIN/MAX which keeps the value however I can't use the new value in my formula. Please help.

[hansolu]

Hi

just add a column in the table with the target value and use a calculated field.

Another way, not sure if its better, is to add the data into the datamodel and make your formulas there. The formulas are a bit more complicate to get the proper totals later.

So easier way, add a target column and use a field.