Forum Discussion
Calculated Field Formula
Hello All, I have an excel pivot table which shows for certain jobs what the price, costs and profit are. Our 3rd Party Supplier then gets a 10% commission on jobs that were actually booked. Not a...
Lorenzo Thank you for that....sadly that is way above my skill level....as I can't find how you add in DAX let alone get that to work. But thank you for answering my question...I didn't realise it only worked on numeric as opposed to text.
Many thanks.
My understanding that in cached PivotTable formulae in calculated field don't work with labels, only with value fields.
As workaround you may add calculated item to Status
which gives
Not exactly what is required, some approximation. To be flexible you need to work wit data model.