Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hello,
I have a pivot table with example 3 column
Cost, Sell, Margin
with data such as: 1,2,50% 1,-,-
The 2nd row has incomplete data. However the measure computed in the AVG for Margin results in 25% since its still include the 2nd row. Can the AVG have a filter so that if the Margin is "-", not to inlcude it in the counts?
Hope this makes sense.
Thanks,
Hi Mike,
In the latest version of the Pivot package we have a property called customAggregates which allows users to define their aggregate operators via values or functions. However, in your case we realize we need to apply custom aggregates for final values as well (i.e. dividing sum by custom count). This needs some additional feature of the Pivot process.
Please send us an email to support@koolphp.net. Once this feature is added in a few days we will send you the latest version of the Pivot process together with guiding how to apply for your case. Thanks!
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo