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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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

E
  • Question
Report that multiplies tables ('tree tables')
Replies
1
Views
80
Cubist
Cubist
A
  • Solved
Calculated Field
Replies
5
Views
165
Alex Blakenburg
A
J
  • Question
Filter Pivot Table Generated From PowerQuery Data Model
Replies
1
Views
127
jdorby
J
B
  • Question
Calculated Field Coming Back as Zero
Replies
4
Views
315
biotbravo
B
A
  • Question
Two dimensional dynamic named range over a pivot table not working as I thought
Replies
4
Views
340
ashleighbrown
A

Forum statistics

Threads
1,215,529
Messages
6,125,344
Members
449,219
Latest member
Smiqer

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