Hello everyone,
I have a pivot table and I'd like to calculate the mode for the week. My data table is arranged by day. The field (in the data table) I'm interested in using is hours. I don't care if the calculation is done within the pivot table or outside. It seems to me that something like:
=MODE(GETPIVOTDATA("Hours",$A$3,"Date",$B5+6)-GETPIVOTDATA("Hours",$A$3,"Date",$B5))
A3 is the upper right of my pivot table, and Column B is the Min date for the group. However it appears that this can only be used for columns that appear in the pivot table. Since I need the data, not come calculation based on the data (sum, avg, product, std, etc) I seem to be stuck.
I have a pivot table and I'd like to calculate the mode for the week. My data table is arranged by day. The field (in the data table) I'm interested in using is hours. I don't care if the calculation is done within the pivot table or outside. It seems to me that something like:
=MODE(GETPIVOTDATA("Hours",$A$3,"Date",$B5+6)-GETPIVOTDATA("Hours",$A$3,"Date",$B5))
A3 is the upper right of my pivot table, and Column B is the Min date for the group. However it appears that this can only be used for columns that appear in the pivot table. Since I need the data, not come calculation based on the data (sum, avg, product, std, etc) I seem to be stuck.
