Merge two amounts field for a field

Q&A
,
1

What is the best way to sum up the amount from two different fields for one of the calculated fields within a pivot table

2

Hi @gulatiku ,

If I understand the requirement correctly, you want to sum 2 fields and then show in a pivot table.

You can create a calculated field and field1 + field 2 should yield result.

Only catch is the aggregation level. We cannot add aggregated measure to a non-aggregate measure. For this you may have to use specific aggregation function with the non aggregated field. For example : field1 is already aggregated but field 2 is non aggregated.

So the modified calc will be field1 + sum(field 2) ,
the aggregation can be sum/avg/ min etc. based on your use case.

Thanks,
Prantika