Hi All,
I am having problem with sum of two different type values .
example : i have address_type like current and former i need to calculate both address type sum value as result .
but when i do sum of current address type fileld i missing former adress type sum values because when i select addresstype its separate current and former.
measure: Insight_Accts_current {
type: number
sql: ${Insight_Active_CA} + ${Insight_Settled_CA} ;;
filters: [address_type: "current"]
sql_distinct_key: ${tran_key} ;;
}
measure: Insight_Accts_former {
type: number
sql: ${Insight_Active_FA} + ${Insight_Settled_FA} ;;
filters: [address_type: "former"]
sql_distinct_key: ${tran_key} ;;
}
here i am adding total sum but i am not getting total sum for current and former
because if address type current former will be set ‘0’ and if address type former current will be set 0 like that i missing the total sum
i need both current and former total sum in this below measure
measure: Insight_Accts {
type: number
sql: ${Insight_Accts_current} + ${Insight_Accts_former};;
}
above example i pivot the address type so i get the result like above screenshot but i need total sum of 8 +(-368) -360 as result.
so please any one help me out to achieve this result