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?
Thank you for writing to us.
Our team is currently working on your case.
We will make sure to reach out to you shortly.
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.
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.
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
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.
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.