values on pivot table doesn't matching

Question

I am doing eocnomic analysis and I need to have the table organized like in the pivot table, but the numbers aren't matching.

As you can see, the numbers in the 1st sheet and in the queries are shown in the right way but when I load the numbers from querie to the pivot table, they aren't correct and don't match.

I don't understand what is happening....

link to screenshoots : HELP FOR EXCEL

Answer 1

Hi there

From the pictures, we notice that Data type might be what is causing the problem

Please, try correcting the Data type in the Power Query table fields

Country Column => should be "Text" type ABC

Date column => should be "Date" type

Interest Rate column=> should be "Decimal" type

Frequency column => should be "Text" type

On the Power Query editor you may also try going to Transform>>> Detect data Type to sort it out

Regards

Jeovany

Answer 2

thank you!