Week over Week Report

Lyn Balberde shared this question 2 years ago
Answered

Hello!


I need to create a Week over Week report, however what I can only see is the Year over Year through subquery. Can anyone suggest a workaround for me to make it possible?


Thank you. :)

Replies (1)

photo
1

Hi Simon,

I already prepare my dataset as like this:

Week | Income

35 | 20,000

36 | 30,000

37 | 45,000

I want my report to have a filter of week number and my report would give me the income of the chosen week, its previous week, percentage  change.

Example the filter I chose is Week 36, the report would give me:

Current Week: 30,000

Previous Week: 20,000

Percentage Change: 33%

On Fri, Oct 15, 2021, 7:18 AM Yellowfin Support, <support@yellowfin.bi> wrote:

Leave a Comment
 
Attach a file