We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

How to hide some measured values for columns

Answered

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?

Attachments:
Screenshot_1.png

2 answers

Jacinth October 15, 2019

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
}
}
}
});

 

Attachments:
Screenshot_1.png

WebDataRocks Team WebDataRocks October 15, 2019

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