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...
Hi wyptaj / Paul
To my knowledge the [Status] field requires Numeric values (not Text ones) for such formula to work in classic Pivot Tables
If you run a Windows version of Excel there's probably a solution with Power Pivot - basic example below and attached
DAX measure for Commission with above Table1 as data source:
=CALCULATE (
SUM ( Table1[Profit] ) * 0.1,
FILTER ( Table1, Table1[Status] = "won" )
)