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