Using GETPIVOTDATA with percentages

[JeffGrant]

Hi All,

when I create pivot table, I have the row headers as integers and the column headers as percentages with a format of no decimal points.

So a column header of 33.333333333333 appears as 33%. No problem there.

However, If I have a lookup value of 33%, then the #ref error is returned because 33.333333333 is not 33.

How do I get GETPIVOTDATA to look up 33, when the column header is 33.333333333

or would I better to use something like Index / Match with an approximate match?

Thanks

 

[JeffGrant]

Problem solved
I added a new column to the source data table, use the Round function on the data that I wanted rounded, and created a new pivot table.