How to prepare pivot table have data MTD and YTD?

[panwipa2528]

1. I have daily raw data from 2 persons. (Data since 1/1/2018-28/5/2019)
2. I want to know sum(Sale) from 1-28 May 2018 & 1-28 May 2019
3. I want to know sum(Sale) from 1-Jan - 28 May 2018 & 1-Jan - 28 May 2019
4. Need to see 2 & 3 same table

[lironbaram · Accepted solution]

Hi 

attach you'll find a qlikview app

with a table with the four expressions you want to display