Forum Discussion

naveen73's avatar
naveen73
Helper III
4 years ago

Power Pivot shows wrong values and format

Hi, I have a strange problem with Power Pivot. Please see screenshot below When using the “normal” pivot table, I am able to get the real values in the last column after doing the filtration i.e. I...
Need Help
Show and Tell
littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

naveen73 would need some sample data to try to recreate and diagnose the issue...

  • naveen73's avatar
    naveen73
    Helper III
    4 years ago

    Appreciate your response and request for data. However, the file is very large (> 60mb).

    What is worth to say, is that in the column "Amount", where the "problem" lies, there are several types of data. All are figures but they range from 0.001% to 2million (2,000,000). The reason for this is the column "Item" are balance sheet items (> 2k) as well as balance sheet ratios (< 1.5%).

    I also change in Power Query the format of the "Amount" column to "%" because I am only interested in the items that are ratios.

     

    Does this help?

    thanks,

    Nav

    Does this help.