Hi,
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 values ?
In the attached sample .qvw, I want to select June (30/06/2022) and the pivot should show values 350, 750, 1350 for Sum, Rangesum 3m & Rangesum 6m respectively for June 2022 only.
Thanks,
Rutger