3 Replies Latest reply on Feb 29, 2016 11:06 PM by thea carp

    Calculate difference in value based on variable date parameters

    thea carp

      Hi all

       

      I have a very simple file with category, subcategory, volume of sales by month (month1, month2, month3).

      Is there a way to calculate the difference in sales between 2 dates that should be selected as a parameter? I want in the final output the users to be able to select 1 date (either month1 or month2 or month3) and then a 2nd date (either month1 or month2 or month3) the my calculated field would compute the difference?

      The trick here is that the user has the option to select any 2 dates

           

      categorydatesubcategoryvolume
      vegetables2016-1parsnip532396
      vegetables2016-1peppers201879
      vegetables2016-1poatatoes128718
      vegetables2016-1tomatoes111497
      fruits2016-1apples91941
      fruits2016-1oranges91031
      fruits2016-1grapes70161
      fruits2016-1figs63867
      fruits2016-1pears54493
      vegetables2015-12parsnip4242534
      vegetables2015-12peppers32321
      vegetables2015-12poatatoes42422
      vegetables2015-12tomatoes11123132
      fruits2015-12apples324242
      fruits2015-12oranges21321
      fruits2015-12grapes1231234
      fruits2015-12figs2321
      fruits2015-12pears13232
      vegetables2015-11parsnip31213
      vegetables2015-11peppers2131321
      vegetables2015-11poatatoes23
      vegetables2015-11tomatoes
      fruits2015-11apples423
      fruits2015-11oranges42322
      fruits2015-11grapes12332
      fruits2015-11figs8576
      fruits2015-11pears545