Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines
Hi, I am trying to find a way to add a suffix to a Measure/Aggregate column on a PivotTable where the Suffix data comes from a field in the Array.
The example is when displaying sales data for a Vodka Bottle, grouped by warehouse, category - I would like to display the resulting Qty as "2.5 Litre" - the "Litre" coming from the same dataset.
What would be the right datapipe to use to concatenate a second field onto the data?
Any help is much appreciated.
HI Ardan,
Supposed you could get "Litre" from your datastore, you could suffix the data cells of PivotTable with "map" property:
$measure = "Litre";
PivotTable::create([
...
"map" => [
'dataCell' => function($value, $cellInfo) use ($measure) {
return $cellInfo['formattedValue'] . " " . $measure;
},
],
...
]);
Let us know if you have any difficulty doing this. Thanks!
Let KoolReport help you to make great reports. It's free & open-source released under MIT license.
Download KoolReport View demo