Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
rutger_jansen
Contributor III
Contributor III

Rangesum in Pivot - allow date selection & preserve rangesum

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

 

Labels (1)
0 Replies