Hello All,

I have a question regarding calling a selected value in a quick filter to the calculated filed.

Here is the requirement

I want to show WoW report something like this (User to pick Week1 vs Week2, I want to use a quick filter instead of Parameter since they are not dynamic)

My Source Data will only have 3 columns

Week      Type           Spend

So for the dashboard purpose, I created two Dimensions (for Quick Filters so users can pick, only Single value select)

• Week1
• Week2

Now I am trying to create metrics

• Week1Spend --> This should be the data for Week1 filter only  --> Question is how do we pass the value selected in Week1 to this and ignore the value selected in Week2 filter
• Week2Spend --> This should be the data for Week2 filter only  -->Question is how do we pass the value selected in Week2 to this and ignore the value selected in Week1 filter
• Variance ($) = Week2Spend – Week1Spend

Attached the sample dashboard. Please check and let me know whether it is possible to achieve with quick filters

Thanks