Non Aggregation

posted on May 31st, 2019

Answered

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

Attachments:
Non aggregate pivot sample1.xlsx
Non aggregated Pivot.jpg

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

Attachments:
Detailed Non Aggregated Pivot Image.jpg

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

Non Aggregation

4 answers

Please login or Register to Submit Answer