Ignoring dimension with set analysis

[nsm1234567]

Hey There,

I'm battling to accomplish something and I'm wondering if someone can assist.  What I'm looking for is a chart that looks like the below.  The dataset I'm starting with is in the attached.  Is it possible to have the chart in the attached look like the below?  Any help would be greatly appreciated.

Brand	Date	Last Year Total	This Year Total
		30498261	38101086
Company1	10/10/2015	30498261	38101086

[Anonymous]

in both of your Expression use aggr around

=aggr(sum(if(TransDateNo=vYesterday,Sales)),Brand)

[nsm1234567]

Hey There,

Thanks for the response.  This works for the specific case I've put forward, but if I were to add more dates the "this year" wouldn't line up with "last year."  What I'm going for is a list of dates with the two columns:  The total for the specific date, and the total for the "last year" date.

[Anonymous]

you should use a master calendar,

i made you a small example with your data (no complete mastercalendar)

look at the attached app

you need to select the year in the yearlistbox (select 2015 and you get both values)

if you only have two years you may adapt this solution