Date dimension/formula problem
I'm not sure what I am trying is possible but here goes.
I have my data stacked as per @GrantSmith's excellent post.
What I need is a calculated column for the last year column that only includes the value if "Another Value" from the This year row = 'Y'
So only show 600 if another value =Y from period type this year
So I have
sum(case when `Period Type` = 'Last year' then `value` end)
Can this be extended to do what I need?
I have tried a few things such as below
case when sum(case when `Period Type` = 'This year' AND `Another Value` = 'Y' then 1 end) = 1 then sum(case when `Period Type` = 'Last year' then `value` end) end
but this won't work...
Any help would be appreciated.
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board