PivotView displaying string data and aggregation configuration
Hi,
I'm utilizing the Syncfusion React EJ2 PivotView to present my data. Below is my data in JSON format:
[
{
"id": "1",
"pokemonPower": "20",
"pokemonName": "Pikachu",
"pokemonAge": 20,
"pokemonSuccessRate": 200
},
{
"id": "1",
"pokemonPower": "20",
"pokemonName": "Pikachu",
"pokemonAge": 50,
"pokemonSuccessRate": 300
},
{
"id": "1",
"pokemonPower": "20",
"pokemonName": "Pikachu",
"pokemonAge": 100,
"pokemonSuccessRate": 500
},
{
"id": "2",
"pokemonPower": "25",
"pokemonName": "Bulbasaur",
"pokemonAge": 20,
"pokemonSuccessRate": 699
},
{
"id": "2",
"pokemonPower": "25",
"pokemonName": "Bulbasaur",
"pokemonAge": 50,
"pokemonSuccessRate": 33400
},
{
"id": "2",
"pokemonPower": "25",
"pokemonName": "Bulbasaur",
"pokemonAge": 100,
"pokemonSuccessRate": 1110
}
]
I want the PivotView to display the data exactly like this:
I've configured the PivotView with the "id" field as rows and the other fields as columns. However, I'm facing two main challenges:
1. I'm unable to display the "pokemonName" in each field. It seems that the PivotViewComponent only accepts numeric values for its cells.
2. The tool automatically aggregates all the records with the same "id" value and displays them in a single row with summed values. I don't want this; I want to see each record separately.
Could you please provide guidance on how I can achieve this? Your assistance is greatly appreciated. If you have any questions about my inquiry, please feel free to ask.
Thank you!
