Vizlib Home Try Vizlib
Welcome
Login

Adding a custom column for difference between two columns in pivot table

Hey everyone!


Is there a way to add a custom column to calculate the variance between two columns that will be dynamic? Here's an example. 

So the user would have to select 2 batallions to compare which are displayed in the columns. I need to create a custom column for the overlap. Is this possible? In this case, a third column will appear and in the 5K fuel trailer row, it'll show -4 since the second batallion has 4 while the first has 0.


image


Login to post a comment