Forum Discussion

Copper Contributor

Apr 25, 2022

Solved

[TCD] Calculer un % en fonction du total d'une autre colonne

Bonjour à tous, Dans mon exemple ci-dessous, j'aimerais calculer le % que représente le volume de ma colonne Pages Vues : Erreurs/Echec (Colonne D) par rapport au montant total de Pages Vues (Col...

excel

Lorenzo
Apr 25, 2022
Hi JorisA

Not sure this is doable with a classic Pivot Table... With Power Pivot (sample attached):
PP_JorisA.xlsx163 KB

Lorenzo

Silver Contributor

Apr 25, 2022

Hi JorisA

Not sure this is doable with a classic Pivot Table... With Power Pivot (sample attached):

PP_JorisA.xlsx163 KB

JorisA
Copper Contributor
Apr 27, 2022
Hi Lorenzo,

Thank you for help !
It is solving my problem perfectly.

Thank you so much !
- Lorenzo
  Silver Contributor
  Apr 27, 2022
  Hi JorisA
  Glad I could help & Thanks for posting back. Note that I later edited my initial response with a revised version of the DAX measures. Feel free to re-download
  Nice day...
  - JorisA
    Copper Contributor
    Apr 27, 2022
    I downloaded the document today, so everything should be fine 🙂
    
    Thank you ! Nice day