Excel Pivot table add two distinct count columns

I have  Excel 2013  pivot table. In this table I have several columns,  two columns have distinct count value.
I am wondering is it possible to add those two  columns and get third column with sum of those two?
Just to add I can not see calculated filed option in PivotTableToos->Analyze->Fields, Items, & Sets it is dimed.
TarasAsked:
Who is Participating?
 
FloraCommented:
calculated field or column cannot be added on the pivot table where it is loaded with option of "Data Model"

and you cannot have unique count if you do not enable data model.

so the solution is that on the source data you add a helped column with formula  and then load it, in pivot table
1
 
abbas abdullaCommented:
Hi,
If you used power pivot to produce that then you can write a measure in the model then use it in the pivot. Share sample of your data if you look for such solution.
0
 
TarasAuthor Commented:
Thank you both a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.