1 Reply Latest reply: Jan 26, 2016 6:16 PM by Stefan Wühl RSS

    Expression Percentage - Help

      Hi, I'm new to data analysis.  I'm using ClikSense Desktop and I need to show a column in a pivot table that shows percentage change from one column to the next:


      Essentially my pivot looks like this:




                                                             Avg([Current Total Dollar Sales])               Avg([Previous Total Dollar Sales])     Avg([Current Total                                                                                                                                                                             Dollar                                                                                                                                                                             Sales])- Avg([Previ                                                                                                                                                                              ous Total Dollar                                                                                                                                                                                 Sales])


      Deluxe                                             $472,222                                                 $400,000                                         $72,222

      Economy                                          $432,987                                                 $400,000                                         $32,987

      Flavored Deluxe                              $423,234                                                  $400,000                                        $23,234

      etc. etc. etc.



      What would my expression be to change the last column to % difference rather than value difference?  I've also attached a screen shot of this section of my app.


      Any help would be so greatly appreciated.