We are using CSV connection for pivot table.
1.I have to find out the Difference between two Columns and show it in next column.
Is there any possibility to do that. Please find the attached screen shot for the same.
Thank you for writing to us.
The desired output can be achieved in the following way:
1. Reorganize the data
We kindly advise organizing the CSV data in the following manner:
Create a column representing every month containing the corresponding value. For example, instead of:
CONTRACT_NUMBER, YEAR, MONTH, VALUE
H0524, 2014, January, 93
H0524, 2014, February, 59
organize the data in the following way:
CONTRACT_NUMBER, YEAR, January, February
H0524, 2014, 93, 0
H0524, 2014, 0, 59
If using a JSON data source it is possible to manipulate the JSON data to achieve the same desired output. This is illustrated in the JSFiddle example.
2. Use calculated measure
Create a calculated measure which will display the difference between January and February:
uniqueName: "Difference of Jan & Feb",
formula: "sum(\"January\") - sum(\"February\")",
caption: "Difference of Jan & Feb"
Here is a JSFiddle example for illustration.
Please let us know if this works fine for you.