2 Replies Latest reply: Apr 16, 2013 2:31 PM by vsiqueira RSS

    Percentage Calculation on Pivot Table

      I'm having a lot of difficulties to calculate the percentage in my pivot table.

       

      I've attached the template of the expected result and some sample data in case it could anyone.

       

      My issue is in a Collum named as % on the block that i'm using year as dimension. As the user can filter data by year and month, this collumn must be able to disregard all the month dimension and sum all the registers from the selected year.

      So, what is needed is present the percentage of model relative to the total of each brand.

       

      On the YTD collum I already have the total from each model by using this expression =Count({1<Ano = {$(#=only(Ano))}>}Numero_Chassis)

       

      Could anyone help me to make this comparison ?

       

      Thanks

      -Vinicius