How to add field twice
My question is how to add same filed two times into table ( ex : min & max of one field),
without using calculated member.
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.
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.
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:
- Create several calculated measures with all the necessary aggregations
- Include the measure with
differenceaggregation to the slice and set “active”: false
Please refer to the code snippet below:
"formula": "average(\"Discount\") ",
"formula": "sum(\"Discount\") ",
"formula": "difference(\"Discount\") ",
We hope this workaround helps.