Get Free Trial
Get Free Trial

Why Pivot table has the field values ?

Answered
ahmad asked on October 14, 2019

Hi , 
 
I am currently trying pivot charts and I have a couple of questions:

  1. I noticed that I always have “summation values” in the rows/columns areas in the fields panel. I do not know why I have this and how to remove it? I tried pivot charts in other tools such as excel and it has no such “values”
  2. Also, I noticed that the names of the areas are different than standard pivot charts. I mean usually, pivot charts have 4 areas (Axis, Filter, Values and Legend). I assume you are following the same standard pivot chart but with different naming. Or at least can we change the naming of these areas?

I would appreciate your response regarding this 
 
Best regards
Ahmad Hossny
 

1 answer

Public
Vera Didenko Flexmonster October 15, 2019

Hello, Ahmad,
 
Thank you for writing to us.
 
Please see our answers below:

1) If we understand you correctly, by “summation values” you mean the aggregation names that are added to the measures’ captions, for example, Sum of ..., Count of ..., etc
This can be turned off by setting showAggeregationLabels: false in the options object:

options: {
viewType: "charts",
showAggregationLabels: false
}

Here is a JSFiddle example for illustration: https://jsfiddle.net/flexmonster/ecknxs8b/

2) About the names of the sections in the Field List ( https://www.flexmonster.com/doc/slice/#!change ):
Flexmonster is a pivot table component and charts are an additional data visualization tool (hence the name: “Flexmonster Pivot Table & Charts”). For this reason, the Field List sections’ names correspond to pivot table namings.
The Field List assists in choosing which fields are to be displayed in the Report Filters, Rows, Columns, and Values report sections.
In case you would like to change the labels for the Report Filters, Rows, Columns, and Values Field List sections, this can be done by setting the desired labels via localization: https://www.flexmonster.com/doc/localizing-component/
 

Please let us know if you have any questions.
 
Best Regards,
Vera

Please login or Register to Submit Answer