Pivot Table

J

Jet01091973

New Member
Joined
May 26, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
I want to insert calculated fields on a pivot table.

however, it will not allow me because i checked the data model box so that I could look at distinct counts.

is there a work around for this limitation ?

JT
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
Limitation, are you being serious? The data model offers DAX measures which are a zillion times better then calculated fields.
However learning DAX, in all it's finesse, is not that easy.

So what kind of calculated field would you need to have in the data model? I'm sure the fine experts here can assist you in writing those DAX.
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Calculated Field Coming Back as Zero
Replies
4
Views
303
biotbravo
B
A
  • Question
Two dimensional dynamic named range over a pivot table not working as I thought
Replies
4
Views
303
ashleighbrown
A
A
  • Solved
Pivot Table Sum giving Zeros but count works
Replies
5
Views
606
RoryA
RoryA
B
  • Question
Calculated Field in pivot table difficulty
Replies
2
Views
312
bluefish44
B
C
  • Question
Confused over pivot table calculations :-(
Replies
1
Views
258
number kruncher
N

Forum statistics

Threads
1,215,054
Messages
6,122,893
Members
449,097
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top