Hello,My case is very simple. How do I count the amount of times that X has Y without having it on my table?Example:My database is: Client Item Price X A 10 X B 5 X C 1 Y A 10 Y D 3 I want my final outcome to be:Client # Items above $4 X 2 Y 1 Thank ...

Hello all,I was wondering how can I have a % difference between a metric shown on data range Y vs the prior data range.Ex. Spend of the last 7 days vs Spend of previous 7 daysDate Filter: Last 7 DaysName: ABC ; Spend Last 7 Days: 100$ ; Spend prior 7...