Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have multiple measures like revenue from product 1 , product 2 , product 3 for each month.
I have the details in the pivot table with the structure mentioned in the attachment.
I want to display a column with sum of last 6 month for each measure.
Any suggestions will be of great help.
It sounds similar to rolling items into quarters, etc. for financials.
I did a quick search for the quarters, etc. in the community, but think that each are helpful (some qlikview, some similar topics).
I think it would be adding two measures: A) 1 being months 1 <= x <= 6, B) being months 7 <= x <= 12)
Community posts that may be helpful:
Consolidating Months into Quarters
https://community.qlik.com/thread/186573
Show data for week,month,quarter,year based on date entered by user.
https://community.qlik.com/thread/148970
Financial Quarter
https://community.qlik.com/thread/161813
Help Calculating Period-over-Period Growth
Thanks Robert. I will check it out