How to add field twice

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

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

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