We truly hope that our free tool comes in handy for your business, especially these days. Follow our news, stay safe & pivot on!

How to hide some measured values for columns


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?


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



WebDataRocks Team WebDataRocks October 15, 2019

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.
WebDataRocks Team

Please login or Register to Submit Answer