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?
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
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
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
