Hi, I add columns Category and some measured values like Price, Quantity, Discount.
But I want to see only Price in columns, and all total values (Price, Quantity, Discount)
How can I hide some measured values for columns?
Is it possible add custom grand totals?
Hi Adkham,
I’m not know the style you want to see very clearly, but let me give a try.
you can try this example https://codepen.io/webdatarocks/pen/RmrgWg
and add some code like following
var pivot = new WebDataRocks({
container: "#wdr-component",
toolbar: true,
report: {
dataSource: {
filename: "https://cdn.webdatarocks.com/data/data.csv"
},
formats: [{
maxDecimalPlaces: 4
}],
slice: {
rows: [{
"uniqueName": "Category"
}],
columns: [{
"uniqueName": "Measures"
}],
measures: [{
"uniqueName": "Price",
"aggregation": "sum"
},
{
"uniqueName": "Quantity",
"aggregation": "sum"
},
{
"uniqueName": "Discount",
"aggregation": "sum"
}]
},
"options": {
"grid": {
showHierarchyCaptions: true,
showHeaders: true
}
}
}
});
Hello,
Thank you for posting your questions here.
WebDataRocks does not support hiding some measure columns. The custom grand totals feature is also not supported.
We recommend checking on Flexmonster, which is a premium pivot component. It allows setting 0 column width using table sizes config. With the help of such an approach, you can make a workaround for custom grand totals.
Regards,
WebDataRocks Team