Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with a conditional sum

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?

1 Reply
Ivan_Bozov
Luminary
Luminary

North: Sum({<Hemisphere={'N'}>}LineTotal)

South: Sum({<Hemisphere={'S'}>}LineTotal)

vizmind.eu