🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Difference of average of row

Answered
Brendan Fry asked on December 15, 2020

Hi,
In the attached screenshot we want the Difference of Row of Total Sales to show the difference between the Average of Total Sales.
Is this possible?
Thanks
Brendan

6 answers

Public
Milena Pechura Milena Pechura Flexmonster December 16, 2020

Hello, Brendan,
 
Thank you for writing to us.
 
Our team is currently working on your case.
We will make sure to reach out to you shortly.
 
Kind regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster December 17, 2020

Hi, Brendan,
 
Thank you for giving us some time to work on this case.
 
Currently, the Difference of Row aggregation can be based on the sum aggregation only.
However, we have added an appropriate task to our backlog. Our team will notify you if there are any updates on this matter.
 
Please let us know if any other questions arise. We would be glad to help you.
 
Best regards,
Milena

Public
Brendan Fry December 18, 2020

Hi,
Thanks. We await the update.
The client is also asking if the first column with difference which is blank could be hidden as there is nothing to compare to and this is confusing them.
Kind Regards,
Brendan

Public
Milena Pechura Milena Pechura Flexmonster December 21, 2020

Hi, Brendan,
 
Thank you for your question.
 
As the only possible solution, we suggest hiding the column by setting width: 0 in report.tableSizes. We have prepared an example for illustration: https://jsfiddle.net/flexmonster/97n35gze/.
 
Please kindly note that this approach hides the column by its index. If the slice is changed, please check whether the idx in tableSizes is defined correctly.
You are welcome to use the setTableSizes API call to specify the new idx if needed.
 
Please let us know if it helps and if any additional questions arise.
 
Best regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster December 29, 2020

Hello, Brendan,
 
Hope you are doing well!
 
We were wondering whether our response helped you with your question.
Could you please let us know if the suggested approach works for your case?
 
Looking forward to hearing from you.
 
Kind regards,
Milena

Public
Milena Pechura Milena Pechura Flexmonster January 21, 2021

Hi, Brendan,
 
How are you?
 
We would like to kindly take an interest in whether our response was helpful.
Please let us know if you successfully hid the first difference column.
 
Waiting for your response.
 
Best regards,
Milena

Please login or Register to Submit Answer