Log In
Register
Home
New Member
March 18, 2020
Offline
Hi
I have added calculated field to my pivot table, the formula was as follows: =MAX('Number of serving days' )/ COUNT(Status)
but the result always showing me the amount of multiplying not subtracting?
can anyone help me with this issue?
July 16, 2010
Offline
Hi Mahmoud,
This isn't Power Pivot, this is a regular PivotTable Calculated Field. You can't do a formula like that with Calculated Fields because the aggregation type is limited to sum, max, min, count, average etc.
Please post a sample Excel file so we can show you how to use Power Pivot to write a DAX measure for this.
Mynda
New Member
March 18, 2020
Offline
Hi Mynda
Actually I dont have power pivot in my excel version ( Office Home Edition) , I have added sample file , the working will be in sheet 3, and the field need to be calculated is (sum of field1) .
is there any way to do that calculation with the current version of excel.
I appreciate your help !
Thanks and Regards
July 16, 2010
Offline
Hi Mahmoud,
I asked because you posted your question in the 'Power Pivot' forum. The calculation can't be done with a regular PivotTable, sorry. You'll have to move the calculation outside of the PivotTable. You can still reference the PivotTable cells in the formula though.
Mynda
1 Guest(s)
