Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Hauglaen
Contributor II
Contributor II

Create trends from different dates

Hi,

I have the following sales data:

DateSales product ASales product BSales product C
jan.20100  
feb.205090 
mar.206060110
apr.20786030
mai.20605030
jun.20  50

 

I want to create a first, second, third ect. sales month.
Rather than compare jan.20 with feb.20.

How can i creat a table like this:

MonthTotal sales
1300
2140
3150
4178
560

 

Thanks!

0 Replies