title: Spotfire: Changing Pivot Data by Filtering Original Data
body: <p>I have managed to enter a data table into Spotfire (version 6.0) and create a pivot from the data table. However I am unable to make it such that when I filter the original data, the pivot reacts to the filter and gets recalculated accordingly.</p>
  
  <p>I am trying to find a way to do this without any coding per se, just trying to see if there is a particular setting that enables this to happen.</p>
  
  <p>Thanks in advance.</p>
  
  <p><strong>EDIT: Example</strong></p>
  
  <p>If I originally have the following table</p>
  
  <p><code>age   loc   own1   own2   own3
   24     W      1      0      1 
   38     N      1      1      0 
   16     N      0      0      0 
   58     S      1      0      0 
   33     W      0      1      1 
   45     N      1      1      1 
   23     S      1      0      0 
   62     N      0      1      0</code></p>
  
  <p>and then I create a pivot on this table to calculate the sum of each own column by location, so by choosing row identifiers as loc, no column titles and values as sum(own*) I get:</p>
  
  <p><code>loc     own3   own2   own1
   string  real   real   real
   N       1.00   3.00   2.00
   S       0.00   0.00   2.00
   W       2.00   1.00   1.00</code></p>
  
  <p>So from this, how can I make the values of the pivot table automatically adjust when I change the filter of the original table. So for example if I change the age filter to above 30 then it will change to:</p>
  
  <p><code>loc     own3   own2   own1
   string  real   real   real
   N       1.00   3.00   2.00
   S       0.00   0.00   1.00
   W       1.00   1.00   0.00</code></p>