Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
vsiqueira, what are your dimensions on this pivot table?
And is pivot functionality required, or will this table stay static once it is completed?
The Dimensions are Brand and Model and is required to be able to expand/collapse.
So I have to present the numbers (Share, YTD, MTD and %) to each brand and model as presented in the layout file (Attached on th original post)
Thanks for the help!