Skip to content

getpivotdata

Excel CUBEVALUE vs SUMIFS & GETPIVOTDATA

Once CUBEVALUE formula came out about 10 years ago along with PowerPivot, I was delighted because it had filled the gap that was missing in SUMIFS and GETPIVOTDATA formulas for certain usage scenario.