Forum Discussion

Matthieu_Peters's avatar
Matthieu_Peters
Copper Contributor
Mar 01, 2022
Solved

Calculated items issue in pivot table

Hi all,   I'm having issue in calculating items in my pivot table. I wish I could add variances and ratios and the right of my table and that it adapts whenever I change my data but it doesn't wor...
excel
  • Martin_Weiss's avatar
    Martin_Weiss
    Mar 28, 2022

    Matthieu_Peters 

     

    you just need to apply a value filter. Right-click on one of the "Clé de répartition" items and select "Filter | Value Filters..."

     

    There you can filter on values the do not equal 0:

     

Matthieu_Peters's avatar
Matthieu_Peters
Copper Contributor
Mar 28, 2022

Martin_Weissthanks a lot for the help.

However I do not have the same layout as previously and all "Clé de répartition" are shown.

 

Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Mar 28, 2022

Matthieu_Peters 

 

you just need to apply a value filter. Right-click on one of the "Clé de répartition" items and select "Filter | Value Filters..."

 

There you can filter on values the do not equal 0:

 

  • Matthieu_Peters's avatar
    Matthieu_Peters
    Copper Contributor
    Apr 12, 2022

    Hello Martin_Weiss 

    Hope you are doing good.

    I have a final question regarding my report.

    I added a % column as for the variance but when I try to remove "0" as you told me previously, it does'nt work anymore and I get that result :

    Did I do something wrong?

Resources