Forum Discussion
vince2397
Feb 08, 2021Copper Contributor
Pivot table custom total formula
Hello, I have created a pivot table, however I am stuck on 3 calculations, 2 of which are show on the attached screenshot. I am trying to see how I can customize a specific cell calculation. ...
SergeiBaklan
Feb 08, 2021Diamond Contributor
Adding data to data model you may add DAX measure like
PerCent:=IF(HASONEVALUE(Table[Date]),
AVERAGE(Table[Percent]),
SUM(Table[Daily GP])/SUM(Table[Daily sales])
)