Forum Discussion

Gervasio1977's avatar
Gervasio1977
Copper Contributor
Jun 04, 2021

GETPIVOTDATA: is there a way to define an Item as "All" or "*"?

Hi, I want to use GetPivotData to get numbers from a Pivot (well, that's what it is for, isn't it?), but I want to get summarized and non-summarised values using the 1 single and elegant formula. In...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 04, 2021

Gervasio1977 Why insist on GETPIVOTDATA when you achieve the same by formatting the pivot table in a different way. On the design tab, choose Report Layout "Tabular" and "Repeat All Item Labels".

 

See attached.

 

Resources