🎉 Flexmonster Pivot Table & Charts v2.8 has arrived!Read the blog post
Get Free Trial
Get Free Trial

Duplicate Cell values while expandAll is true

Answered
Ravi asked on January 8, 2020

Hi Team,
 Pivot Table showing duplicate cell values while pivot config has expandAll : true.
Please find the fiddle link to reproduce this issue.
https://jsfiddle.net/ravimarch7/pfw3mg1s/
Note: Don’t suggest to change the Pivot config in any case.

new Flexmonster({
container: "#pivot-container",
componentFolder: "https://cdn.flexmonster.com/",
width: "100%",
height: 430,
toolbar: true,
report: {
"dataSource": {
"type": "csv",
"filename": "data/sales.csv"
},
"slice": {
"rows": [
{
"uniqueName": "Category",
"levelName": "Category",
"filter": {
"members": [
"category.[condiments].[bbq sauce]",
"category.[breakfast cereals].[corn flakes]",
"category.[confectionery]",
"category.[bakery].[chocolate biscuits]",
"category.[fruit preserves].[apple jam]",
"category.[bakery].[apple cake]",
"category.[soups].[tomato soup]"
]
}
}
],
"columns": [
{
"uniqueName": "[Measures]"
},
{
"uniqueName": "Payment Method"
},
{
"uniqueName": "Region",
"levelName": "Region"
}
],
"measures": [
{
"uniqueName": "Revenue",
"aggregation": "sum",
"format": "2sfou03a"
},
{
"uniqueName": "Shipping Cost",
"aggregation": "sum"
}
],
"expands": {
"expandAll": true
}
},
"options": {
"grid": {
"showTotals": "off"
}
},
"conditions": [
{
"formula": "#value < 2500",
"isTotal": false,
"measure": "Revenue",
"format": {
"backgroundColor": "#df3800",
"color": "#FFFFFF"
}
},
{
"formula": "#value > 20000",
"isTotal": false,
"measure": "Revenue",
"format": {
"backgroundColor": "#00A45A",
"color": "#FFFFFF"
}
}
],
"formats": [
{
"name": "2sfou03a",
"thousandsSeparator": ",",
"decimalSeparator": ".",
"decimalPlaces": 2,
"currencySymbol": "$",
"positiveCurrencyFormat": "$1",
"nullValue": "",
"textAlign": "right",
"isPercent": false
}
],
"version": "2.7.22",
"creationDate": "2020-01-08T12:17:14.746Z"
}
});

2 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 9, 2020

Hello, Ravi,
 
Thank you for reporting about that inconsistent behavior.
 
The fix for the described issue is going to be provided with ETA 10.02.2020.
 
Please contact us in case additional questions appear.
 
Best regards,
Illia

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster February 11, 2020

Hi, Ravi,
 
We are glad to inform you that the issue with duplicating some header cells in columns when subtotals are off was fixed.
 
This is included in the 2.8.0 version of Flexmonster: https://www.flexmonster.com/release-notes/
 
You are welcome to update the component. Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/ 
 
Please contact us in case any questions arise.
 
Best regards,
Mykhailo

Please login or Register to Submit Answer