Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

I need 'percentage of parent row/column' similar to excel

Answered
Catalin Bratu asked on November 26, 2019

Hi,
I have a multilevel hierarchy with one measure, ‘Total Pallets’ and I need to display this measure as a percentage of parent cell. I’ve tried ‘% of Column of Total Pallets’, but it is not working as expected, it shows percentage of grand total, similar to ‘% of Grand Total of Total Pallets’ aggregation. 
I have attached 2 screenshots, one with my output, the other with an excel scenario I want to simulate.
It is a must to achieve this type of visualisation, so any advice will be super!
Thanks.

8 answers

Public
Vera Didenko Flexmonster November 27, 2019

Hello,  
 
Thank you for writing to us. 
 
 
Currently, we have the following percentage aggregations: % of Row, % of Column, % of Grand Total: https://jsfiddle.net/flexmonster/8vq9Lgjs/ 
We would like to explain that calculating the percentage based on the parent’s subtotal is not possible at the moment. 
 
If we understand your case correctly, you would like to calculate the result based on the parent’s subtotal, for example:  
Instead of this: 
                                      Customer 

Month                            Company A 

    Payment Method       Sum of Revenue               % of Column of Revenue 

January                                 15 395.00                    6.33% 

    Bank Transfer                    7 667.50                     3.15% 

    Credit Card                        7 727.50                     3.18% 
 
 
You would like to achieve the following:  
                                      Customer 

Month                            Company A 

    Payment Method        Sum of Revenue               % of Column of Revenue 

January                              15 395.00                      6.33% 

    Bank Transfer                 7 667.50                       49.81% 

    Credit Card                     7 727.50                       50.19% 
 
We have added your request to our customer’s wishlist and we will inform you in case of any changes regarding this feature.
 
 
Please let us know if you have any further questions. 
 
Best Regards, 
Vera 

Public
Catalin Bratu November 27, 2019

Hello,
Thanks for your answer, even if it is not the expected one :(. I’ll have my fingers crossed that you will come with a fix for this issue soon.
On the other side, why not implement a more general solution, by providing an API to register custom aggregate functions?  
 
Best Regards,
Catalin
 

Public
Vera Didenko Flexmonster November 28, 2019

Hello, Catalin,
 
Thank you for the feedback and for sharing your ideas with us.
 
We have added this suggestion to our customer’s wishlist.
 
You are welcome to write to us in case further questions arise.
 
Best Regards,
Vera

Public
Mawada December 17, 2019

this not clear for me, how to apply on the calculated value

Public
Vera Didenko Flexmonster December 18, 2019

Hello, 

 
Thank you for reaching out to us.

In Flexmonster aggregations are not applied on calculated values because calculated values define their own formulas.
We would like to explain that calculating the percentage based on the parent’s subtotal is not implemented at the moment and it seems it is not possible to achieve such calculations with calculated values.

We will inform you in case such a calculation is implemented.

 
Please let us know if you have any further questions.

 
Best regards,
Vera
 

Public
Ricardo Gaspar December 19, 2019

Hi,
We are trying flexmonster pivot table and we are enjoying it.

I was trying to get a “percentage of parent row/column” has mention above, also with no success… Google it and found this!
This was a really cool feature, too bad it does not exist!
 
Regards,
Ricardo

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster December 20, 2019

Hello, Ricardo,
 
Thank you for reaching out to us.
 
We do agree that it is a nice feature to have, that is why we have already added it to our backlog. Still, such a feature requires a tangible amount of developments that do not fit into the existing roadmap.
 
We will notify you as soon as something is changed.
 
Please contact us in case any additional questions arise.
 
Regards,
Illia

Public
Vera Didenko Flexmonster February 25, 2020

Hello, Catalin, Mawada, and Ricardo,
 
We are happy to announce that a percentage of parent row/column total aggregation was added.

This is available in the major release version 2.8 of Flexmonster: https://www.flexmonster.com/release-notes/

You are welcome to update the component. Here are our updating tutorials for guidance:
1) Migration guide from 2.7 to 2.8 
2) Updating to the latest version

Please feel free to write to us in case any questions arise.
 
Kind regards,
Vera

Please login or Register to Submit Answer