Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Pivot table: make Sum current month - 12

I have a pivot table (image), as dimensions I have YEAR, MONTH, company name, pdr. As an Expression I have Sum (CONSUMO_SMC)
I would need by selecting the years 2021 and 2020 that this table would show me the Sum (CONSUMO_SMC) from the current month to the current month -12 is it possible?

1Qlik.jpg

.. and i add: I would also like to have in the last column, after the Grand total, the total number of MONTHS that have a value> 0

0 Replies