This content has been marked as final.
Show 5 replies

1. Re: ZN Sum a subset of a column
Shinichiro Murakami Jun 12, 2018 5:18 PM (in response to Kate Jones)
exclude_null_SM_10.4.twbx 1.2 MB


2. Re: ZN Sum a subset of a column
Kate Jones Jun 12, 2018 8:39 PM (in response to Shinichiro Murakami)Unfortunately no, without the zeros showing it gives the impression that there is an amount where none exists. For example, Jan 18 2015 now looks to have an amount between 1 & 3 even though the real sum is 0.

3. Re: ZN Sum a subset of a column
Shinichiro Murakami Jun 12, 2018 9:58 PM (in response to Kate Jones)
exclude_null_SM_10.4_v2.twbx 1.2 MB


4. Re: ZN Sum a subset of a column
garth.conrad Jun 12, 2018 10:10 PM (in response to Kate Jones)1 of 1 people found this helpful1) Change your same day calculation to:
if [Ship Mode]="Same Day" then 1 else 0 end
2) Add a calculated field "MOD Same Day":
if { FIXED [Order date week]: sum([Same Day])}>0 then
if [Same Day]=0 then "Hide"
ELSE
"Show"
END
ELSE
"Show"
END
3) Add "MOD Same Day" to filters and use "Show" values only.
G

5. Re: ZN Sum a subset of a column
Kate Jones Jun 14, 2018 6:53 AM (in response to garth.conrad)Thanks Garth! this was the solution I needed.