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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
GillesB
Contributor II
Contributor II

complex pivot table

Hi
I'm trying to build a complex Pivot (see picture)

image Pivot.png

Up to now, I created 1 measure per line
I can easily do the month per month + total view, that's pivot basics

But I need help for the 2 semestrial columns and the 2 other columns (Year to date = months before current month & Year to go = Months from current month and after) that I need to pu on the same pivot table

I added sample data added to the post, so if you can help me, I'll be very thankfull 

Thanks a lot

0 Replies