
1. Re: Creating Calculated Field across Columns
Shinichiro Murakami Feb 11, 2016 1:17 PM (in response to Kirby Lafferty)Here is a set of formulas.
Filter,(Cookie and Sand)
{fixed [Store]:sum([Cookie])}*{fixed [Store]:sum([Sandwich])}>0
Filter,(only Cookie)
{fixed [Store]:sum([Cookie])}*{fixed [Store]:sum([Sandwich])}=0 and {fixed [Store]:sum([Cookie])}>0
Filter,(only Sand)
{fixed [Store]:sum([Cookie])}*{fixed [Store]:sum([Sandwich])}=0 and {fixed [Store]:sum([Sandwich])}>0
Thanks,
Shin

cokkie,sandwitch_9.0.twbx 6.2 KB


2. Re: Creating Calculated Field across Columns
pooja.gandhi Feb 11, 2016 1:23 PM (in response to Kirby Lafferty)Or you can simply break apart your items dimension in 2 measures like:
Cookie Sale : IF [Items] = 'Cookie' then [Sale] end
Sandwich Sale: IF [Items] = 'Sandwich' then [Sale] end
Categories:
if sum([Cookie Sale]) = 0 and sum([Sandwich Sale]) != 0 then 'Sandwich Only'
elseif sum([Cookie Sale]) != 0 and sum([Sandwich Sale]) = 0 then 'Cookie Only'
elseif sum([Cookie Sale]) != 0 and sum([Sandwich Sale]) != 0 then 'Sandwich and Cookie Both'
end