Get Free Trial
Get Free Trial

Non Aggregation

Kiran Pasham asked on May 31, 2019

We have a requirement in Pivot where the Values in Pivot should not be aggregated.
Idea is to provide “None”/”Do not summarize” option along with SUM, COUNT, MAX near Values section of pivot.
Please check attached sample data expected in Non aggregated data tab.
 
When Multiple values are present, then we can show as empty
 
 
 

4 answers

Public
Vera Didenko Flexmonster June 3, 2019

Hello, Kiran,
 
Thank you for your question.
 
We would like to point out that in Flexmonster the flat form is used for displaying non-aggregated data.
 
This can be done by setting the grid type option to flat:
 

options: {
grid: {
type: "flat"
}
}

 
Here is a JSFiddle example for illustration
 
Please let us know if this works fine for you.
 
We are looking forward to hearing from you.
 
Best Regards,
Vera

Public
Kiran Pasham June 3, 2019

Hi Vera,
 
Thank you for the information but we are looking for non-aggregated data in PIVOT and not in FLAT data. 
Please check attached image.
 
Thanks & Regards
Kiran

Public
Kiran Pasham June 4, 2019

Hi Vera,
 
Can you please let us know on this?
 
Thanks & Regards
Kiran
 

Public
Vera Didenko Flexmonster June 4, 2019

Hello, Kiran,
 
 
Thank you for your response.
 
 
May we suggest two different ways:
 
 
1) Using classic form
 
The classic form can be set the following way:

options: {
grid: {
type: "classic"
}
}

 
We have prepared a JSFiddle example for illustration.
 
More information about the options object can be found in our guide
 
 
2) Using customizeCell
 
    1. Specify the customizeCellFunction in the customizeCell parameter:

customizeCell: customizeCellFunction

 
    2. Define the function:

function customizeCellFunction(cell, data) {
if (data.recordId && data.measure.uniqueName == "On Date") {
if (data.recordId.length > 1)
cell.text = "";
}
}

 
Here is a JSFiddle example for illustration
 
We would like to add that you can use a customizeContextMenu() API call to add new elements to the context menu
 
Please let us know if this works for you.
 
 
We are looking forward to hearing from you.
 
 
Best Regards,
Vera

Please login or Register to Submit Answer