Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
tan_chungkam
Creator
Creator

Set Analysis

Hi all,

I have a sample excel file with contain 2 years of Margin figure.

I wanna get a accumulated margin from the beginning of the year till the latest month period.

The box current showing the total of whole year 2017 Margin which is wrong.

It should be 550 (a sum up of 201701-201704).

For example, now the current year month is 201804. The box should show the sum margin figure of 201701-201704.

When i filter it to 201803, then the box should show the sum margin figure of 201701-201703.

Hope you guys could understand what i mean.

Please find attached as my all required file.

 

Labels (3)
11 Replies
PradeepReddy
Specialist II
Specialist II

check the below link

YTD/QTD/MTD

tan_chungkam
Creator
Creator
Author

Hi @PradeepReddy ,

This is work!!!

Thank you.

But it only solved 1 of my issues.

My another issues is i wanna make Previous year of YTD.

Any idea to do that?