I have a pivot where weeks are displayed as columns and revenue is the value. The user picks the week numbers to compare revenue, so for instance week 7 and week 8 can be displayed at the same time. I want to add a column that calculates the difference between the chosen weeks. They change every week, so this week i might choose 7 and 8 but then next week 8 and 9. How do I do that in Looker?
LinkedIn
Twitter
