Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-06-21 01:24 PM

Rangesum over more than 1 column

Hi,

Is there anyway to do a rangesum over more than one column.

For example.

Pivot table with Year, Quarter, Month and Rate

Want to be able to show month1 rate = month1 Rate, Month2 = Month1+ Month2 etc

Rangesum works fine up to Month3, then Quarter changes to Q2 and the sum starts again. I want to be able to add Month3 rate +Month4 rate.

Any help would be great.

Thanks

294 Views
0 Likes
0 Replies