Forum Discussion

joe_2802's avatar
joe_2802
New Member
8 years ago
Solved

Compare values based on date filter

Apologies for a possibly dumb question and thanks in advance:

 

I require to create two tables based on the data both with indepedent date filters. So far, so good.

 

I need a third table however, that gives me the change in carrots and percentage dynamically based on the respective date filters of the two tables. For example:

 

Report 1:

 

DateCategoryCarrotsPercentage
02.03.2017Donald2.630.266.58081,59
02.03.2017Bugs Bunny113.204.1333,51
02.03.2017Micky190.531.0165,91
02.03.2017Goofy186.729.2465,79
02.03.2017Mini53.912.5541,67
02.03.2017Richy48.941.2521,52

 

Report 2:

03.03.2017Donald2.631.032.71481,62
03.03.2017Bugs Bunny115.348.2123,58
03.03.2017Micky186.748.7485,79
03.03.2017Goofy186.875.5535,80
03.03.2017Mini54.630.1541,69
03.03.2017Richy48.949.3971,52

 

How can I report 3 have dynamically calculate based on the respective filters so I can add it to my dashboard?

Report 3:

CategoryChange in CarrotsChange in Percentage
Donald766.1340,02
Bugs Bunny2.144.0800,07
Micky-3.782.267-0,12
Goofy146.3080,00
Mini717.6000,02
Richy8.1460,00

 

Thanks so much!

2 Replies