Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a fact table with LineTotal reflecting the value of each transaction a CustomerID linking the sale to a customer dimension.
Within the customer dimension, there is an attribute called Hemisphere with a value of N for Northern or S for Southern.
How do I write a function for a measure that will only sum LineTotal when a customer lives in the relevant hemisphere?
North: Sum({<Hemisphere={'N'}>}LineTotal)
South: Sum({<Hemisphere={'S'}>}LineTotal)