https://community.qlik.com/t5/App-Development/Rangesum-in-Pivot-allow-date-selection-amp-preserve-rangesum/m-p/2010562#M83576 <P>Hi,</P> <P>I have a pivot with a Rangesum expression. Is it possible to have a dimension in the pivot and use the same field for making selections whilst keeping the same Rangesum&nbsp; values ?</P> <P>In the attached sample .qvw, I want to select&nbsp; June (30/06/2022) and the pivot should show values 350, 750, 1350 for Sum, Rangesum 3m &amp; Rangesum 6m respectively for June 2022 only.</P> <P>Thanks,</P> <P>Rutger</P> <P>&nbsp;</P> Tue, 29 Nov 2022 17:53:43 GMT rutger_jansen 2022-11-29T17:53:43Z https://community.qlik.com/t5/App-Development/Rangesum-in-Pivot-allow-date-selection-amp-preserve-rangesum/m-p/2010562#M83576 <P>Hi,</P> <P>I have a pivot with a Rangesum expression. Is it possible to have a dimension in the pivot and use the same field for making selections whilst keeping the same Rangesum&nbsp; values ?</P> <P>In the attached sample .qvw, I want to select&nbsp; June (30/06/2022) and the pivot should show values 350, 750, 1350 for Sum, Rangesum 3m &amp; Rangesum 6m respectively for June 2022 only.</P> <P>Thanks,</P> <P>Rutger</P> <P>&nbsp;</P> Tue, 29 Nov 2022 17:53:43 GMT https://community.qlik.com/t5/App-Development/Rangesum-in-Pivot-allow-date-selection-amp-preserve-rangesum/m-p/2010562#M83576 rutger_jansen 2022-11-29T17:53:43Z