Hey!
We truly hope that our free tool comes in handy for your business, especially these days. Follow our news, stay safe & pivot on!

How to add field twice

Answered

Hi,
My question is how to add same filed two times into table ( ex : min & max of one field),
without using calculated member.
Best regards.

3 answers

WebDataRocks Team WebDataRocks February 4, 2019

Hello, Mohamed!
Thank you for posting your question.

Unfortunately, there is no possibility to add multiple aggregations to the same measure except as through using calculated values.
However, adding multiple aggregations is possible in an extended version of WebDataRocks – Flexmonster.
Please let us know if you have any other questions regarding the functionality of a pivot table component.

Kind regards,
WebDataRocks team

Ramakrishna July 6, 2020

HI,
for the above, its not working using calculated values also.
I have 1 measure Quantity and i want to display the difference of that quantity in another column using calculated value.
but it seems for both only default sum aggregation is used.
can you help.
Best Regards

WebDataRocks Team WebDataRocks July 14, 2020

Hello, Ramakrishna,
 
Thank you for your question. 
 
We would like to let you know that this is a known issue related to the difference aggregation. Our team can suggest the following workaround for this issue:

  1. Create several calculated measures with all the necessary aggregations
  2. Include the measure with difference aggregation to the slice and set “active”: false

 
Please refer to the code snippet below:

        "measures": [
{
"uniqueName": "Average",
"formula": "average(\"Discount\") ",
"caption": "Average"
},
{
"uniqueName": "Sum",
"formula": "sum(\"Discount\") ",
"caption": "Sum"
},
{
"uniqueName": "Diff",
"formula": "difference(\"Discount\") ",
"caption": "Diff"
},
{
"uniqueName": "Discount",
"aggregation": "difference",
"active": false
}
]

We hope this workaround helps.
 
Best regards,
WebDataRocks team

Please login or Register to Submit Answer