Multiple Set Analysis In an Equation

[evansabres]

Hello I am attempting to structure an equation with a couple of conditions.

The first equation is:

=NUM(Sum({<fmlyGRP= {'Juices'}>}salesTTL), '$##,###.##')

and I want to include this as well:

=NUM(Sum({<Location = {'Food Truck'}>}salesTTL), '$##,###.##')

I am attempting to find the total sales where the 'Location' is equal to 'Food Truck' and the 'fmlyGRP' is equal to 'Juices'

How would this be structured?

[Anonymous · Accepted solution]

=NUM(Sum({<fmlyGRP= {'Juices'},Location = {'Food Truck'}>}salesTTL), '$##,###.##')