Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Newbie7
Partner - Creator II
Partner - Creator II

Rangesum of column (Month) and row (Year) in a pivot table

Hello,

I'd like to write a rangesum formula in order to sum up both column and rows in the pivot table like below, which is only currently summing up columns.  

Newbie7_0-1633134626798.png

I'd appreciate it if you could let me know how I can modify the measure expression below (especially the yellow highlighted syntax) in order to achieve the cumulative sum of year and month.  

Newbie7_2-1633134776721.png

 

Thank you & best regards,

 

0 Replies